DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Restrict user privs

  1. #1
    Join Date
    Apr 2002
    Posts
    61

    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.

  2. #2
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97

    Lightbulb

    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

  3. #3
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    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

  4. #4
    Join Date
    Apr 2002
    Posts
    61

    thanks

    Thanks Marcio.68 and TomazZ for your feedback. Agree, grant to public is a bad idea. Will see what we can do.

  5. #5
    Join Date
    May 2001
    Posts
    736
    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
  •  


Click Here to Expand Forum to Full Width