Home » RDBMS Server » Security » Grant object privileges to a role on other schema objects
Grant object privileges to a role on other schema objects [message #39145] Thu, 20 June 2002 09:16 Go to next message
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.
Re: Grant object privileges to a role on other schema objects [message #39152 is a reply to message #39145] Fri, 21 June 2002 00:42 Go to previous message
Oskar
Messages: 26
Registered: May 2002
Junior Member
Finally I found it so I'm replying myself ;P

http://asktom.oracle.com/pls/ask/f?p=4950:8:954116::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:738935832390,%7Bgrant%7D%20and%20%7Bprivileges%7D
Previous Topic: Verifying database role
Next Topic: how to audit sql statment thr' audit /trigger in 8.1.7
Goto Forum:
  


Current Time: Tue Oct 26 06:39:43 CDT 2021