If you have grant priveledge issue the following command.
grant all on object_name to user;
Enias Toroveyi
Applications Support Analyst-Team Leader
Bits Africa
+263 4 75374 - 9 - Business
+263 4 781714 - Fax
+263 11 634 099 - Cell
Service excellence is not our policy... it is our business!
-----Original Message-----
From: Rajavardhan
[mailto:oracledba-ezmlmshield-x28750280.[Email address protected]
Sent: Wednesday, May 30, 2007 11:55 AM
To: LazyDBA Discussion
Subject: all privileges to user
Hi
Gurus
How do assign all object privileges to user
Thanks & Regards
V.Rajavardhan Reddy
Software Engineer
GSS America Infotech Ltd.
Block B, 3'rd Floor,
Cyber Gateway,
Hi-Tech City,
Hyderabad.
Tel:- 040-40028700
Fax:- 040-40028703
Visit us: http://www.gssamerica.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page