Grant select on another owners table
From: Bryan Grenn <kp40.v922034_at_kodako.kodak.com>
Date: 1996/04/15
Message-ID: <4ku4c0$l3r_at_kodak.rdcs.Kodak.COM>#1/1
Date: 1996/04/15
Message-ID: <4ku4c0$l3r_at_kodak.rdcs.Kodak.COM>#1/1
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