Grant select on schema

[Former Member]

Me as a User can i execute the following statements via sql editor?

Grant select on schema system to _sys_repo with grant option;

Grant select on schema _sys_bic to _sys_repo with grant option;

Grant select on schema Schema_orders to _sys_repo with Grant Option;

Is there a grant Insert or grant update or grant delete's? since i always see select, i thought select statements.

Thanksa  lot for the helpful info.

[Former Member · Accepted solution]

Yes, you can if your user has the USER_ADMIN system privilege.

Yes, there are grant insert, delete, update, alter, execute, drop etc.

Thanks

[Former Member · Accepted solution]

Anooj,

Is it same if i do grant select from here or via usermgmt> authorizatio > sql privilege tab for a specific user?

And when i give teh grant select privilege to a user, In which table does it write to? i mean the user privilege info to _sys_bic, _Sys_BI or _Sys_Repo?

Thanks.

[Former Member · Accepted solution]

Yes, its the same.

In, Grant select on schema system to _sys_repo with grant option; - the authorisation gets assigned to user _SYS_REPO. You will be able to find schema SYSTEM under SQL privileges of user _SYS_REPO with the SELECT access.

Thanks.

[Former Member · Accepted solution]

Hi Anooj,

       I have the User_Admin granted to my System Privilege but I am able to execute only the

Grant select on schema _sys_bic to _sys_repo with grant option; statement from my User id.

As a system User I am unable to execute the Grant select on schema "My_Schema" to _sys_repo with Grant Option;. statement.

Not sure what I am doing wrong in both the cases.

[former_member194780 · Accepted solution]

Hi Sanjog,

Not sure if I understood your query correct but anyway. You can try with executing procedures.

Check this out :

-Avinash