SQL Server: Grant user access permission to database

Categories: Database; Tagged with: SQL • SQL Server; @ October 17th, 2012 12:20

Grant user permission to login to the database:

USE YOUR_DB

CREATE USER ROA_NAME FOR LOGIN ROA_NAME

Add user to the group:

USER YOUR_DB

EXEC SP_ADDROLEMEMBER 'DB_DATAREADER', 'ROA_NAME'

“Members of the db_datareader fixed database role can run a SELECT statement against any table or view in the database.”

 

Links:
http://stackoverflow.com/questions/6688880/how-do-i-grant-read-access-for-a-user-to-a-database-in-sql-server

FlashBuilder4.7 Beta2发布: New cross platform development features and enhancements <-> BIDS: Sorting files in SSIS/DTSX projects

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects