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.