Re: user creation

anjalm74_at_yahoo.com (ANJAL) wrote in message news:<17f23855.0211102301.318cb793_at_posting.google.com>...
> Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3DC1607F.941F17F8_at_exesolutions.com>...
> > Billy Verreynne wrote:
> >
> > > ANJAL wrote:
> > >
> > > > can anyone tell me how to creat user similar to oracle user in unix
> > >
> > > In Oracle or in Unix?
> > >
> > > --
> > > Billy
> >
> > And what do you mean by similar?
> >
> > Daniel Morgan
>
> in unix, similar means have same profile like oracle but restricted
> previleged, so that user can't login with oracle username in sql plus.

Are you using what used to be called OPS$ accounts? (that means you can use the OS to control what someone is logged in as). In the older way of doing things, the oracle unix login has special privileges because he is a member of the dba unix group. The actual oracle login in such a case would be OPS$ORACLE, although you wouldn't normally login to sqlplus that way. What you might be asking is, can you have another login using the same directories and such, but not be oracle. The answer to that could be yes, create another unix username, with the same default directory but a different userid/groupid. It's been too long since I have done such things to recall all the ramifications. It may even be possible to use the same uid and a different group. But you probably just want to create another unix user and copy over the .* files, unless there is more that you are not telling us.

I used to routinely create my username backwards at places that for some insane reason required a csh login.

jg

--
@home.com is bogus
SQL> !sqlplus `ps -ef|grep sqlplus|grep -v grep|awk '{print $9}'`