grant issue [message #192735] |
Wed, 13 September 2006 07:18 |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
hello
i created an application where hr user is the owner of tables indexes, sequences,procedures.functions...
now everytime i create a new user for this application,i have to grant this user explicitly everything under hr schema
ex: grant newuser select on hr.sales;
grant newuser execute on hr.dropsales;
etc....
is there a way since all the objects are owned by hr user to grant it in one command like:
grant all on hr to newuser
oracle 9i DS windows xp
oracle database 10G
thanks
|
|
|
Re: grant issue [message #192756 is a reply to message #192735] |
Wed, 13 September 2006 08:19 |
Liza79
Messages: 74 Registered: September 2006
|
Member |
|
|
You can create a role once. Grant all required priviliges to the roles.
Now whenever a new user is there just grant him that role.
Either you can have a PL/SQL program which get a list of all objects from HR schema and then grant rights on those objects in a loop. Or something like that.
The Command you are asking, i don't think there is a command like that.
Liza
|
|
|
|
|