CODEWITHSUNDEEP
sqloracle-databaseoracle11gprivileges
Mamta Vyas
Mamta Vyas

Reputation: 93

How to grant privileges on trigger and synonyms in oracle 11g

I have created a sample application to get schema of all objects and generate SQLfile, so I simply created two user, user 'SYSTEM' and 'SCOTT' , and user SYSTEM grant all privileges to access some of tables,views,function etc. to user SCOTT, for grant privileges to user SCOTT use following oracle query

GRANT ALL ON table_name to username

But the problem is this query is not working for trigger and synonyms. so anyone please suggest me how can I grant privileges on triggers and synonyms to user SCOTT.

Upvotes: 3

Views: 44075

Answers (2)

Lucy82
Lucy82

Reputation: 693

How about GRANT SELECT ON dba_triggers to SCOTT;

This way triggers will be visible to user Scott.

Upvotes: 0

Lalit Kumar B
Lalit Kumar B

Reputation: 49082

But the problem is this query is not working for trigger and synonyms. so anyone please suggest me how can I grant privileges on triggers and synonyms to user SCOTT.

  • TRIGGER - You cannot t give grants for trigger. There is no such thing. Triggers fire automatically whenever the trigger event is done on the table on which the the trigger is created. You only need to grant privilege on the table.

  • SYNONYM - You just create a synonym for the schema.table and grant privilege on the table such that other users doesn't have to fully qualify the table and just use the synonym instead.

Upvotes: 5

Related Questions