OraFAQ Forum: Forms » grant issue

Home » Developer & Programmer » Forms » grant issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Report message to a moderator