Privilege Question

[gaegoori]

What kinds of privilege do I need to grant to users in order for them to compile a package on other schema?

[rafiq]

Hi Gaegoori,

There are couple of options for these:

1) you have to be the owner of that package

or 2) Somebody gave you the privilege to execute that pacakge with admin option

or 3) you have to have the dba privilege


Thanks
Babu

[dave777]

Actually, that user must have following privileges:

ALTER ANY PROCEDURE
CREATE ANY PROCEDURE
DROP ANY PROCEDURE
EXECUTE ANY PROCEDURE

Regards.

[nagarjuna]

Originally posted by rafiq
Hi Gaegoori,

There are couple of options for these:

1) you have to be the owner of that package

or 2) Somebody gave you the privilege to execute that pacakge with admin option

or 3) you have to have the dba privilege


Thanks
Babu

2. Somebody gave you execute privilege on that package with "WITH GRANT OPTION" not the "WITH ADMIN OPTION"

3. The user with DBA cannot grant privileges on others objects unless he has privileges with "WITH GRANT OPTION"

-nagarjuna

[jmodic]

Originally posted by nagarjuna
3. The user with DBA cannot grant privileges on others objects unless he has privileges with "WITH GRANT OPTION"

... or unless this is a Oracle9i Rel.2 database. In 9.2 DBA can grant/revoke object privileges for objects from other schemas without the need to obtain "WITH GRANT OPTON" privilege first.

[nagarjuna]

Originally posted by jmodic

Originally posted by nagarjuna
3. The user with DBA cannot grant privileges on others objects unless he has privileges with "WITH GRANT OPTION"

... or unless this is a Oracle9i Rel.2 database. In 9.2 DBA can grant/revoke object privileges for objects from other schemas without the need to obtain "WITH GRANT OPTON" privilege first.

) I am an 8i OCP. I have to learn 9i.

thanx for the information.