locked
SQL SERVER BASIC SECURITY RRS feed

  • Question

  • Hi,

    When I create a new user that user does not have any permissions on the database tables.But it has select permissions
    for example on sysindexes table.I wanto revoke all permissions that this newly created login has and I just want to grant permissions that I want.

    How can I do create a user without any permision in the SYSTEM and then I will set the permission one by one.

    Thank you for your replies...
    Friday, October 31, 2008 1:55 AM

Answers

  • Revoke SELECT on sysindexes to public

     

    You can run that in each of the databases that you want to deny this to, and it will revoke the right.

    Sunday, November 2, 2008 3:57 AM

All replies

  • remove guest user from your database. 

    Friday, October 31, 2008 6:48 PM
  • quest user can not be removed from the database.But it can be disabled and it is already disabled.
    Saturday, November 1, 2008 10:03 PM
  • Revoke SELECT on sysindexes to public

     

    You can run that in each of the databases that you want to deny this to, and it will revoke the right.

    Sunday, November 2, 2008 3:57 AM