SQL Server 2008 how do I grant privileges to a username

Question

I need to be able to establish an ODBC connection through SQL Server authentication    In SSMS how do I grant permission for a user to be able to have ALL RIGHTS on a specific database   is there a way to do this graphically with SSMS

User · Answer

Like the following  It will make the user database owner   EXEC sp addrolemember N db owner   N USerNAme

User · Answer

If you want to give your user all read permissions  you could use   EXEC sp addrolemember N db datareader   N your-user-name    That adds the default db datareader role  read permission on all tables  to that user   There s also a db datawriter role - which gives your user all WRITE permissions  INSERT  UPDATE  DELETE  on all tables   EXEC sp addrolemember N db datawriter   N your-user-name    If you need to be more granular  you can use the GRANT command   GRANT SELECT  INSERT  UPDATE ON dbo YourTable TO YourUserName GRANT SELECT  INSERT ON dbo YourTable2 TO YourUserName GRANT SELECT  DELETE ON dbo YourTable3 TO YourUserName   and so forth - you can granularly give SELECT  INSERT  UPDATE  DELETE permission on specific tables   This is all very well documented in the MSDN Books Online for SQL Server   And yes  you can also do it graphically - in SSMS  go to your database  then Security  gt  Users  right-click on that user you want to give permissions to  then Properties adn at the bottom you see  Database role memberships  where you can add the user to db roles

User · Answer

If you really want them to have ALL rights   use YourDatabase go exec sp addrolemember  db owner    UserName  go

[sql] SQL Server 2008: how do I grant privileges to a username?

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008

Examples related to ssms