Post reply

Permissions when adding a new user??

  • October 24, 2008 at 5:16 am

    #383209

    When setting up a new user what are the default permissions assigned to the user by SQL Server 05?

    For example, does a new user have permission for such things as:

    1) Creating a new table?

    2) Creating a new database?

  • October 24, 2008 at 9:06 am

    #889290

    First, when you grant access to a SQL Server instance, you create a login. When you grant that login access to a database in the instance, you create a user.

    Logins and user don't have any default permissions, except to connect to the intance and the database, until they are granted permissions. So a new login can't create a database unless it's been granted CREATE DATABSE, CREATE ANY DATABASE, or ALTER ANY DATABASE. A new user can't

    create a table unless it's been granted CREATE TABLE permission.

    Greg

  • October 24, 2008 at 9:21 am

    #889297

    That great to know, thanks for your help!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply