Home » Other » General » Oracle granting user the permission to create packages how to?
Oracle granting user the permission to create packages how to? [message #101897] Tue, 13 November 2001 06:51 Go to next message
rex
Messages: 7
Registered: November 2001
Junior Member
How do i(dba) grant a user the privileges to create packages.
I tried..
GRANT CREATE PACKAGE TO dbuser;
Didn't work.
I'm not a Database specilist, so am not aware of the syntaxes, and given the time constraints i dont have to time to learn. so please help.
I'm more of a java programmer..trying to get some work on database side by creating user and giving some privilegs.
Regards
Rex

----------------------------------------------------------------------
Re: Oracle granting user the permission to create packages how to? [message #101901 is a reply to message #101897] Thu, 15 November 2001 09:25 Go to previous message
Chris
Messages: 128
Registered: November 1998
Senior Member
Try
GRANT CREATE ANY PACKAGE
or
GRANT CREATE ANY PROCEDURE

----------------------------------------------------------------------
Previous Topic: Re: How to install oracle8i and developerr 2000 release 2.1
Next Topic: Re: Datawarehousing professionals for US
Goto Forum:
  


Current Time: Sun May 19 16:23:18 CDT 2024