Home » Developer & Programmer » Forms » grant issue
grant issue [message #192735] Wed, 13 September 2006 07:18 Go to next message
maoro
Messages: 310
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 Go to previous messageGo to next message
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
Re: grant issue [message #192831 is a reply to message #192756] Wed, 13 September 2006 16:43 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I agree with everything Liza said.

True, there's no thing like "GRANT everything ON whole_schema TO someone_else".
Re: grant issue [message #192900 is a reply to message #192735] Thu, 14 September 2006 03:06 Go to previous message
maoro
Messages: 310
Registered: May 2005
Senior Member
thanks for both of you
Previous Topic: Link between forms and reports
Next Topic: Package Related
Goto Forum:
  


Current Time: Fri Dec 02 18:47:21 CST 2016

Total time taken to generate the page: 0.43908 seconds