Package body,triggers are not appearing on "Connect" user [message #599100] |
Tue, 22 October 2013 04:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ishika_20
Messages: 339 Registered: December 2006 Location: delhi
|
Senior Member |
|
|
Dear All,
I need to create a user who has have only view privilges.
Below are my steps-
*************** To create new user and assigned to users TB ************************
create user genisys
identified by genisys
default tablespace users
*************** Grant connect session to user *******************************
grant connect to genisys
grant execute any procedure to genisys
grant select any table to genisys
grant SELECT ANY SEQUENCE to genisys
grant execute ANY type to genisys
I know that "EXECUTE ANY PROGRAM" / "EXECUTE ANY PROCEDURE" will allow user to do changes if user has privilges other than "CONNECT" role. Now, problem is, package body / triggers are not appearing under "GENISYS" user.
Kindly Assist me to sort-out the problem.
Regards,
Ishika
|
|
|
|
|
|
|
|
|
Re: Package body,triggers are not appearing on "Connect" user [message #599127 is a reply to message #599123] |
Tue, 22 October 2013 06:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ishika_20
Messages: 339 Registered: December 2006 Location: delhi
|
Senior Member |
|
|
Dear Michel,
What is the functional needs for this?
>> developer, doesn't have access to this DB but they want to check the procedure/table/packages which found Invalid.
Why do you mean EXACTLY by SELECT? You don't select a procedure.
>> Developer can query data from the tables and its respective views / can see the packages and its body / triggers.
Here, SELECT means, specified user can query.
This is what our requirement.
|
|
|
|
Re: Package body,triggers are not appearing on "Connect" user [message #599134 is a reply to message #599127] |
Tue, 22 October 2013 07:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
ishika_20 wrote on Tue, 22 October 2013 12:12Dear Michel,
What is the functional needs for this?
>> developer, doesn't have access to this DB but they want to check the procedure/table/packages which found Invalid.
Why do you mean EXACTLY by SELECT? You don't select a procedure.
>> Developer can query data from the tables and its respective views / can see the packages and its body / triggers.
Here, SELECT means, specified user can query.
This is what our requirement.
Perhaps you could grant SELECT ANY TABLE as you have done, with SELECT ANY DICTIONARY and EXECUTE ON DBMS_METADATA to give access to the source code? I haven't tried this.
It is a weird requirement.
|
|
|
|
Re: Package body,triggers are not appearing on "Connect" user [message #599205 is a reply to message #599137] |
Wed, 23 October 2013 00:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ishika_20
Messages: 339 Registered: December 2006 Location: delhi
|
Senior Member |
|
|
Dear John,
I have given below accesses to the user but still he can't see package body/triggers. Though able to view package specification.
*************** Grant connect session to user *******************************
grant connect to genisys
grant execute any procedure to genisys
grant select any table to genisys
grant SELECT ANY SEQUENCE to genisys
grant execute ANY type to genisys
grant execute ANY program to genisys
grant execute on dbms_metadata to genisys
grant select any dictionary to genisys
When I give provide DBA privileges then user can able to view all the package body along with its respective specifications.
Dear Michel,
Requirement is like that, developer can see the object over testing database through provided user name.
Regards,
Ishika
[Updated on: Wed, 23 October 2013 00:26] Report message to a moderator
|
|
|
|