Ladies_Tailor Posted November 13, 2013 Report Posted November 13, 2013 oracle stored procedure ki multiple owners assign cheyocha???? change owner command dhorikindi but is it possible to keep multiple owners... Experts plz advise . it's bit urgentt :(
peru_edaite_enti Posted November 13, 2013 Report Posted November 13, 2013 I don't think so... you can only have one owner defined for procs in oracle AFAIK
Ladies_Tailor Posted November 13, 2013 Author Report Posted November 13, 2013 I don't think so... you can only have one owner defined for procs in oracle AFAIK ohh .. is it... Owner kakunda migatha users ki Execute permissions ivvacha??
Ka NTR i Posted November 13, 2013 Report Posted November 13, 2013 ohh .. is it... Owner kakunda migatha users ki Execute permissions ivvacha?? yep. Execute privilege ivvu. synonym create chesuko aa schema lo...so that it appears like its owned object.
annu11abcdef Posted November 13, 2013 Report Posted November 13, 2013 In oracle every sproc will be run under schemas...Each user can have their own schemas..like the same there will be schema for admin users as well. grant privileges on object to user; (specify user name in oracle) Command isthe you can give whatever permission for any object to a particular user.. Ex: nuvvu okadiki only select ivali ante grant select on suppliers to User (user name)
Ka NTR i Posted November 13, 2013 Report Posted November 13, 2013 In oracle every sproc will be run under schemas...Each user can have their own schemas..like the same there will be schema for admin users as well. grant privileges on object to user; (specify user name in oracle) Command isthe you can give whatever permission for any object to a particular user.. Ex: nuvvu okadiki only select ivali ante grant select on suppliers to User (user name) adding notes to the above one ... You can give any privs(select,insert,update,delete) on tables,views,materialized views. And you can give only execute privs on procedures,functions and packages. And to make a note you can also grant the privs with grant option so that other user also can able to grant privs to the other users.
Ladies_Tailor Posted November 13, 2013 Author Report Posted November 13, 2013 thanxs guys... inni options unnaya .. greatt... inni unna multiple owner concept matram ledu :(
Recommended Posts