OraFAQ Forum: Server Administration

Sun, 16 January 2005 22:12

saishankar
Messages: 1
Registered: January 2005

Junior Member

Hi
How can i grant permission on a package for the users? what r the permissions available on a package

Sun, 16 January 2005 22:59

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

You can only grant EXECUTE and DEBUG on a given package to other users:

SQL> grant execute on dbms_output to scott;

Grant succeeded.

SQL> grant debug on dbms_output to scott;

Grant succeeded.

Best regards.

Frank

Previous Topic:	Database Link
Next Topic:	cloning a database.prob:Pl. see scenario.

Goto Forum:

]

Current Time: Fri Jan 10 03:35:46 CST 2025