-
Restrict user privs
I have some tables that have grant select to public. So, by default, when I create a new user, the user is allowed to select data from these tables. Now business rules have changed. I need to give select priv to on only selected tables, but these tables have grant select to public priviously assigned. Without revoking this grant, is there any way that I can restrict selected users not to select data from these tables?
Thanks in Advance.
-
You can create rules for reading of these tables, and to give Grant of this rules for the users whom it desires.
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
-
Rather than searching for workarounds make a plan of revoking from public.
It's a very bad practice.
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
-
thanks
Thanks Marcio.68 and TomazZ for your feedback. Agree, grant to public is a bad idea. Will see what we can do.
-
Originally posted by marcio.68
You can create rules for reading of these tables, and to give Grant of this rules for the users whom it desires.
u mean roles.There is no such thing in database called as rules.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|