Re: Question about revoking select from PUBLIC
- From: Brian Peasland <dba@xxxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Sep 2007 14:08:44 -0500
bontemps wrote:
All of our tables have PUBLIC synonyms and of course PUBLIC has SELECT
privileges on all of them. How can I make some of them visible ONLY to
certain users?
You'll have to revoke SELECT access from PUBLIC and then grant SELECT access only to those that need to see the table.
> If I drop the PUBLIC synonyms, nobody except the owner
can see them.
Actually, if you drop the public synonym, they will still be able to access the table. That is because PUBLIC has been granted SELECT access on the table. They will just need to use schema-dot notation to access the table, i.e. they need to prepend the table name with the owner and a period as in SCOTT.EMP.
> If I keep the PUBLIC synonyms everyone sees them. We
know that we can drop the synonym and include the schema owner when
referencing the table name but we dont want to rewrite the application
to insert them.
The PUBLIC syn does not let them query the table. The SELECT priv (object privilege) does.
HTH,
Brian
--
===================================================================
Brian Peasland
dba@xxxxxxxxxxxxxxxxxxx
http://www.peasland.net
Remove the "nospam." from the email address to email me.
"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
--
Posted via a free Usenet account from http://www.teranews.com
.
- Follow-Ups:
- Re: Question about revoking select from PUBLIC
- From: bontemps
- Re: Question about revoking select from PUBLIC
- References:
- Question about revoking select from PUBLIC
- From: bontemps
- Question about revoking select from PUBLIC
- Prev by Date: Question about revoking select from PUBLIC
- Next by Date: Re: Question about revoking select from PUBLIC
- Previous by thread: Question about revoking select from PUBLIC
- Next by thread: Re: Question about revoking select from PUBLIC
- Index(es):
Relevant Pages
|
