Home » RDBMS Server » Security » Grant privilege to "user b" for object in schema "user a" (10g, SLES9)
Grant privilege to "user b" for object in schema "user a" [message #361817] Fri, 28 November 2008 02:58 Go to next message
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
Member
I apologise for asking questions I should be able to read up, but my time is extremely limited (high pressure environment).

Question - Can I do something like the following:

I have a procedure usera.proc1

Can I: grant drop procedure usera.proc1 to userb


I try, and get this:

ERROR at line 1:
ORA-00990: missing or invalid privilege

but I am not sure if this is at all possible - am I trying to grant a privilege that is not possible ?
Re: Grant privilege to "user b" for object in schema "user a" [message #361818 is a reply to message #361817] Fri, 28 November 2008 02:59 Go to previous messageGo to next message
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
Member
PS. I am trying to stay away from the "grant any" privileges, eg.

grant drop any procedure to userb;

Re: Grant privilege to "user b" for object in schema "user a" [message #361825 is a reply to message #361817] Fri, 28 November 2008 03:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No you can't.

Regards
Michel
Re: Grant privilege to "user b" for object in schema "user a" [message #361859 is a reply to message #361817] Fri, 28 November 2008 05:04 Go to previous messageGo to next message
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
Member
Thank you Michel
Re: Grant privilege to "user b" for object in schema "user a" [message #361922 is a reply to message #361817] Fri, 28 November 2008 10:28 Go to previous messageGo to next message
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
Member
I also found the following very helpful link (it gives an explanation of every privilege:

http://www.ss64.com/ora/grant_privs.html


For example:

PROCEDURES:

CREATE PROCEDURE Create stored procedures, functions, and packages in grantee's schema
CREATE ANY PROCEDURE Create stored procedures, functions, and packages in any schema
ALTER ANY PROCEDURE Alter stored procedures, functions, or packages in any schema
DROP ANY PROCEDURE Drop stored procedures, functions, or packages in any schema
EXECUTE ANY PROCEDURE Execute procedures or functions (standalone or packaged) Reference public package variables in any schema

Smile
Re: Grant privilege to "user b" for object in schema "user a" [message #361925 is a reply to message #361922] Fri, 28 November 2008 10:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle documentation gives that you don't need to search.

But as you said: "I am trying to stay away from the "grant any" privileges".

Regards
Michel
Re: Grant privilege to "user b" for object in schema "user a" [message #361934 is a reply to message #361817] Fri, 28 November 2008 11:08 Go to previous messageGo to next message
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
Member
I had to learn Oracle very fast, so I am still a little unsure of which information to find in which Oracle document (in the manuals) - for example which one contains all the privilege information. I also saw mention on the web about an Oracle Database Security Guide (when searching for privileges).

Oracle has quite a lot of documents.


Dirk
Re: Grant privilege to "user b" for object in schema "user a" [message #361939 is a reply to message #361934] Fri, 28 November 2008 11:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle has also a great search engine at home page of each release of at http://www.oracle.com/pls/db102/db102.federated_search for all versions.

Regards
Michel
Re: Grant privilege to "user b" for object in schema "user a" [message #361945 is a reply to message #361817] Fri, 28 November 2008 11:39 Go to previous message
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
Member
Thank you Michel
Previous Topic: How to trace activities of all users on the database
Next Topic: Oracle Database
Goto Forum:
  


Current Time: Fri Mar 29 06:04:14 CDT 2024