[askdba] Re: Assigning user rights without roles

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Mon, 4 Jul 2005 23:32:13 +0200

Alter Session Set Current_Schema = <new user>

I think that is what you want .. 

Cheers
Ganesh

On 04/07/05, Subodh Deshpande <subodh_deshpande@xxxxxxxxx> wrote:
> Dear All,
> 
> I really have forgotten, how to set a user another users rights and privs 
> without assinging him role explictly.
> 
>  e.g. scott is a user, test is another user
> i will issue a comamnd like set user scott=test by which scott will act as 
> test user in that session
> 
> can somebody please help me..
> 
> Good Luck..Subodh Deshpande
> 
> ===============================================
> Experience Is Knowledge
> Wisdom Is Philosophy
> ==============================================
> 
> --
> _______________________________________________
> NEW! Lycos Dating Search. The only place to search multiple dating sites at 
> once.
> http://datingsearch.lycos.com
> 
>

Other related posts: