CODEWITHSUNDEEP
oracle-databasetriggerssql-grant
Prakash Mani
Prakash Mani

Reputation: 115

Create user in oracle database

I have below requirement in oracle database

  1. Create User and grant to all objects in schema "abc"
  2. If i add any tables to schema "abc", then the user should have access by default without executing individual Grant

Current we are executing Grant statements for every objects created in schema, is there any onetime configuration available? Please help

Note: Here user is not a schema owner, for ex. some one who having access to read-only access.

Upvotes: 0

Views: 464

Answers (1)

Colin 't Hart
Colin 't Hart

Reputation: 7729

In current versions of Oracle, you could create a DDL Trigger and have this automatically execute a grant on the newly created object to your other user.

See the excellent PSOUG site for an overview: http://psoug.org/reference/ddl_trigger.html

Upvotes: 1

Related Questions