[askdba] Re: Assigning user rights without roles
- From: "Subodh Deshpande" <subodh_deshpande@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Wed, 06 Jul 2005 02:18:16 -0500
yes ganesh..this what i want..thanx :)
----- Original Message -----
From: "Ganesh Raja" <ganesh.raja@xxxxxxxxx>
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Assigning user rights without roles
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
> >
> >
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: