-
Privilege that are needed!!
scott user has lots of Procedure/Packages and Package Bodies.
As an user I want to see the Procedure/Packages and Package Bodies of scott,
debug,alter and compile them.What are the privs that need to be given.
Thanks
-
Alter any procedure & execute any procedure. Be careful, this is not a recommeded practice.
Thanx,
Sam
Thanx
Sam
Life is a journey, not a destination!
-
From the system user I have Granted the alter any procedure & execute any procedure .
I logged out and Logged in my schema.But still I am not able to see Scott's ...Procedure and Packages using the Toad...
-
How are you trying to check through toadd
Thanx
Sam
Life is a journey, not a destination!
-
I am Logging with the userid Subha ,select the scott user(from the dropdown menu) and Looking for the Procedure and Packages ...
-
you must of done something wrong then as it works for me here
-
SQL> select * from session_privs ;
PRIVILEGE
----------------------------------------
ALTER SYSTEM
CREATE SESSION
ALTER SESSION
DROP ANY TABLE
SELECT ANY TABLE
INSERT ANY TABLE
UPDATE ANY TABLE
DELETE ANY TABLE
CREATE VIEW
CREATE ANY VIEW
DROP ANY VIEW
SELECT ANY SEQUENCE
ALTER ANY PROCEDURE
EXECUTE ANY PROCEDURE
14 rows selected.
-
Can you compile or debug or execute the scott's package from sqlplus. Remember to qualify with the schema name i.e scott
If you encounter any error, please remeber to include them too on the post.
Thanx
Sam
Life is a journey, not a destination!
-
I can do everything in Procedure and packages.But Package Bodies I am not able to see .....
-
Originally Posted by Subha
I can do everything in Procedure and packages.But Package Bodies I am not able to see .....
GRANT SELECT ANY DICTIONARY TO .....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|