| Grant object privileges to a role on other schema objects [message #39145] |
Thu, 20 June 2002 09:16  |
Oskar
Messages: 26
Registered: May 2002
|
Junior Member |
|
|
Hi,
I wrote a package using a small data model in order to achieve three goals (not neccesarily ordered this way):
1. Create private synonyms for several users for objects allocated in different schemas.
2. Grant roles to several users.
3. Grant different privileges on several objects to several users.
I use literals, lists or strings ended with % as params depending on the task I want to do.
Points 1 and 2 work fine.
I have my package on SYSTEM schema.
My only question is:
Isn't there any other way to success on point three other than previously GRANT explicitly every object from wanted schema WITH GRANT OPTION to SYSTEM?
I think that's the only way but maybe some of you can think of a better one.
Thanks in advance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
