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

You will need to look into granting right access via roles or explicitly (e,g grane select on table to userA).

Also, bear in mind, when you grant execute to a package owned by user A to user B, when user B runs it, it will run with the permissions of user A (unless you say otherwise).

M

xnatch_at_yahoo.com (idan) wrote in message news:<3bd6ece1.0204242255.2e179f02_at_posting.google.com>...
> 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
Received on Thu Apr 25 2002 - 15:51:23 CEST