Object Privilege Issue

[former_member221711]

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

[thirus11]

Hi Madhu,

NOTE: Not all object privileges are applicable to all kinds of database objects.

You need grant the privileges to other user

GRANT is used to grant privileges and structured privileges to users and roles. GRANT is also used to grant roles to users and other roles.

In order to use the GRANT command to grant privileges to other users and roles, a user must have the privilege and also the permissions required to grant that privilege.

For example:

You grant DELETE privilege for this table (tab) to the 'P' user.

GRANT DELETE ON sch_name.tab TO P;

You grant the P user the privilege to create any kind of object in the sch_name schema.

GRANT CREATE ANY ON SCHEMA sch_name TO P;

Hope this is helpful!!

Best Regards,

Thiru

[former_member221711]

Hi,

When i tried to execute the below command

GRANT SELECT ON SCHEMA "IEVCS_J16" TO P1941474291

I am getting the below error.

Could not execute 'GRANT SELECT ON SCHEMA "IEVCS_J16" TO P1941474291'

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized.

The issue here is the OWNER as you can see in the screen shot i have attached earlier with my post is "_SYS_REPO" thats because i did had the option to specify the owner when i created the schema from the UI while i was creating the project.

Thanks

Madhusudan