How to give dbo_access to a user on a database?

• venu_ksheerasagaram

  SSCommitted

  Points: 1911

  More actions

  July 24, 2009 at 7:37 am

  #208673

  Hi,

  I have an issue here which goes as follows;

  1) How to give dbo_access to a user?

  2) What is the use of schemas?

  3) What is the difference between Schemas and Membership roles?

  4) How to remove a user having the schema as db_accessadmin?

  5) please provide me the links to know more clearly about how to give the exact permissions to a user on a database?

  Thanking you all in advance,

  Venu Gopal.K
  Software Engineer
  INDIA

• ps.

  One Orange Chip

  Points: 29422

  More actions

  July 24, 2009 at 8:07 am

  #1029696

  venu_ksheerasagaram (7/24/2009)

  ---

  Hi,

  I have an issue here which goes as follows;

  1) How to give dbo_access to a user?

  2) What is the use of schemas?

  3) What is the difference between Schemas and Membership roles?

  4) How to remove a user having the schema as db_accessadmin?

  5) please provide me the links to know more clearly about how to give the exact permissions to a user on a database?

  Thanking you all in advance,

  Are those interview questions? some of the answers are too simple and u can get those by reading through BOL.

  ---

  
  Pradeep Singh

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  July 24, 2009 at 10:14 am

  #1029845

  Hi Venu,

  Check these links. I'm sure that you will become security expert by following these great articles.

  http://www.sql-server-performance.com/articles/dba/sql_security_p1.aspx

  http://www.sql-server-performance.com/articles/dba/authorization_2005_p1.aspx

  http://www.sql-server-performance.com/articles/dba/Analyzing_SQL_Server_Permissions_p1.aspx

  http://www.developer.com/tech/article.php/10923_721441_2

  http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sqlserver2005logins/2474/

  http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/

  http://www.mssqltips.com/tip.asp?tip=1138

  http://www.mssqltips.com/tip.asp?tip=1714

  http://www.mssqltips.com/tip.asp?tip=1718

  http://www.mssqltips.com/tip.asp?tip=1282

  http://www.mssqltips.com/tip.asp?tip=1478

  http://www.mssqltips.com/tip.asp?tip=1227

  http://www.mssqltips.com/tip.asp?tip=1214

  http://www.sqlservercentral.com/articles/Security/sqlserversecurityfixeddatabaseroles/1231/

  http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server/default.aspx

  http://www.sqlservercentral.com/articles/Administration/sql_server_security/578/

  http://www.sqlservercentral.com/articles/Administration/sqlserversecurityfixedroles/1163/

  Thank You,

  Best Regards,

  SQLBuddy

• Gingkoo

  SSChasing Mays

  Points: 644

  More actions

  July 24, 2009 at 10:24 am

  #1029855

  1) How to give dbo_access to a user?

  sp_rolemember 'db_owner','username'

  or sp_changedbowner 'username' (if you like)

  2) What is the use of schemas?

  Enable more granular security within a database. You can assign right to a schema.

  3) What is the difference between Schemas and Membership roles?

  one is a set of objects and the other is server prinicpal to which you can assign other server principals.

  4) How to remove a user having the schema as db_accessadmin?

  That isn't schema, is a server role. but the answer is sp_dropsrvrolemember

  5) please provide me the links to know more clearly about how to give the exact permissions to a database?

  put GRANT into Books Online, the rest will follow.