A synonym problem
From: Frank Greene <74200.427_at_CompuServe.COM>
Date: 9 Feb 1995 00:10:34 GMT
Message-ID: <3hbmhq$pp6$1_at_mhadg.production.compuserve.com>
Date: 9 Feb 1995 00:10:34 GMT
Message-ID: <3hbmhq$pp6$1_at_mhadg.production.compuserve.com>
Problem with synonyms --
User_one owns table table_one. We create role role_one which,
among other things, grants select on table_one.
Now create a new user user_two and grant role_one to that user.
When we log on as user_two, apparently the only way to access
table_one
SELECT * FROM USER_ONE.TABLE_ONE;
That is, fully qualify the table name.
Real bummer for code developers. THE QUESTION: is there any way
to
is via something like
create a private synonym which is attached to to a role in such a
come along with it?
Received on Thu Feb 09 1995 - 01:10:34 CET