OraFAQ Forum: Security » Grant privilege to "user b" for object in schema "user a"

Home » RDBMS Server » Security » Grant privilege to "user b" for object in schema "user a" (10g, SLES9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Grant privilege to "user b" for object in schema "user a" [message #361817]

Fri, 28 November 2008 02:58

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 ?

Report message to a moderator

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

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;

Report message to a moderator

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

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No you can't.

Regards
Michel

Report message to a moderator

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

dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa

Member

Thank you Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68417
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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68417
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

Report message to a moderator

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

dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa

Member

Thank you Michel

Report message to a moderator

Previous Topic:	How to trace activities of all users on the database
Next Topic:	Oracle Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 18:22:41 CDT 2023