Re: Grant select on another owners table
Date: 1996/04/15
Message-ID: <4ku8l6$878_at_instasrv.admin>#1/1
The only way I know of is to have the owners, yyyyyy and zzzzzz, do the grants. If yyyyy and zzzzzz have granted someone else 'with grant option' then someone else can pass on their access.
Bryan Grenn (kp40.v922034_at_kodako.kodak.com) wrote:
: Problem : I'm creating a new user and I was asked to grant that user
: select access on:
: xxxxxx.tablea
: yyyyyy.tableb and
: zzzzzz.tablec.
:
: I have the password for account xxxxxx, but the users have
: developed tables under yyyyyy and zzzzzz that they support.
: How do I grant access to these tables without involving the
: owners of yyyyyy and zzzzzz ? I know I can change the password
: for these accounts, do it and change them back, but I don't want
: to affect the user if they happen to try to login at the same
: time. Is there a way ?????
Received on Mon Apr 15 1996 - 00:00:00 CEST