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

----------------------------------------------------------------------

Report message to a moderator

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

----------------------------------------------------------------------

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 12:36:59 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.