-
I need a help. I got a procedure. I want to grant priviledge to someone else so that they can make changes on the procedure. But I am not sure how to do it.
Thanks a lot!
(-)
-
Hi, U can use with Grant Option
A Winner never Quits, A Quitter never Wins
Ganesh .R
-
Hi,
In order to give access to the procedure so that the other user can make changes is to .The SYS user should give him ALTER ANY PROCEDURE system privelege.And u as a user should give him EXECUTE PRIVELEGE on the procedure.
If the procedure contains undelying tables in ur schema,then u should also grant him necessaty privliges on the tables to that user.
for e.g.
Say a procedure proc1 is in SCOTT schema.And u want to give him access to make changes to the procedure as well as run that procedure to user A
Step 1)Connect as sys and
grant alter any procedure to A;
Step2)Connect as user SCOTT and
grant execute on proc1 to A;
if the procedure is accessing some tables in SCOTT schema,u have to grant the necessary priveleges on the underlying tables to user A also,
In case of any doubts please be free to ask me at rohitsn@altavista.com
Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com
-
thank's a lot for the answers guys!
(-)
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
|