Re: Giving "like owner" permissions for users on Oracle

Thanks, but,
won`t there always be commands that MUST be ran under the owner ? I would like to make the owner "unusable".. meaning that no-one should use it, no matter what...

Rick Wessman <Rick.WessmanNO_SPAM_at_oracle.com> wrote in message news:<aa8r2b0dbj_at_drn.newsguy.com>...
> One way to do it would be to create a role, grant the privileges necessary to do
> the tasks to the role, and then grant the role to the users.
>
> Rick
>
> In article <3bd6ece1.0204242255.2e179f02_at_posting.google.com>, xnatch_at_yahoo.com
> says...
> >
> >Hello.
> >Anyone knows if there is a way to give "owner permissions" to users?
> >I mean, now some of the users in my organization MUST use the owner
> >users for specific tasks. I would like them to work only with personal
> >users.
> >
> >is this possible in Oracle 9i or in any other way?
> >
> >Thanks!
> >
> >Idan
>
> Rick Wessman
> Oracle Corporation
>
> The opinions expressed above are mine and do not necessarily reflect
> those of Oracle Corporation.
Received on Tue Apr 30 2002 - 15:41:29 CEST