Post reply

Permissions

  • May 18, 2005 at 6:21 am

    #102535

    Hi all,

    Quick question - am I right in thinking that if a login is only given 'public' permissions on a database they do not actually have access to do anything, not even selects?  It just gives them the right to access the database?

    Also, I thought that it was only possible to have one db owner, but you can also set db_owner on a login when you set it up, even if the actual dbo is another user.  Does this mean that everyone with db_owner permissions will have the same access as the db owner of the database?

    Hope this makes sense

    Thanks!

    Paula.

  • May 18, 2005 at 6:25 am

    #559542

    Public access gives the user what ever permissions are assigned to the public role.

    You can have one database owner, but many people in the dbo group.

    dbo's have full access to the database in question.

    Steven

  • May 18, 2005 at 6:31 am

    #559545

    Thanks, that makes sense. 

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

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