Skip to Content
0
Former Member
Feb 17, 2016 at 08:00 AM

Object Privilege Issue

22 Views

Hi Experts,

I have created a repository work space logging in as USER 'A' (SAY) and went ahead creating project at which point it has given a option to create a schema( name = SCH). I have created few tables in the schema logging in as A user. Now when i am trying to grant access to the schema SCH under object privilege to another user say 'P' i see the options are greyed out.

Generally we create schema with the command

CREATE SCHEMA sch_name OWNER user_name,

but i have created using the option i got while creating the project as mentioned earlier.

Please check the attached screen shot.

Thanks & Regards

Madhusudan

Attachments