| EXECUTE privilege [message #112410] |
Thu, 24 March 2005 19:27  |
Hina
Messages: 51
Registered: April 2004
|
Member |
|
|
Which privilege a user should have, so it can be assign an EXECUTE privilege on specific objects to other users.
e.g
A user (app_admin) has to assign an EXECUTE privilege on objects which has already created, or will be created under following schemas.
analyst
research
sales
Thanks
|
|
|
|
| Re: EXECUTE privilege [message #112541 is a reply to message #112410] |
Sat, 26 March 2005 22:48  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
This is a pure "its in the docs" question in my mind...specifically, read the entire page about GRANT in the SQL REFERENCE BOOK. It will point you at other places that you can read if you need more info.
And only certain things, such as procedures, are executable. Others are not.
Oh and one other approach is to have the schema who owns the objects be responsible for granting all of the necessary permissions to those objects. But it is a matter of style.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
