Home » RDBMS Server » Security » Grant privs to public user (Oracle 11.1.0.7.0.7)
Grant privs to public user [message #515255] Sat, 09 July 2011 08:12 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,

grant insert,update,delete,select on staging_tb1 to public;


What is public here? i know something about public user like it is users exist in the database .

Am i correct ?

Thanks
Re: Grant privs to public user [message #515257 is a reply to message #515255] Sat, 09 July 2011 08:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/E11882_01/network.112/e16543/authorization.htm#DBSEG40048
By granting those privs to public, you are actually granting it to all users in database.
Re: Grant privs to public user [message #515261 is a reply to message #515255] Sat, 09 July 2011 12:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you read the books we already pointed you many and many and many times?

Regards
Michel
Re: Grant privs to public user [message #515269 is a reply to message #515261] Sat, 09 July 2011 13:38 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Because. (Michel, you're a guy on the left)
Re: Grant privs to public user [message #515273 is a reply to message #515269] Sat, 09 July 2011 14:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Very good one. /forum/fa/2115/0/
This is indeed the reason. Laughing

Regards
Michel
Re: Grant privs to public user [message #515287 is a reply to message #515273] Sun, 10 July 2011 02:35 Go to previous message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Thank you Mahesh... Smile
Previous Topic: Create user with non expiring password
Next Topic: How to change DEFAULT_ROLE of a user
Goto Forum:
  


Current Time: Thu Mar 28 11:12:56 CDT 2024