Started by Austin at November 16, 2016 - 5:06 AM
One, new user and authorization
The new password for account appuser, 163.com, and allows the user to the appdb database test table has a select, insert, update permissions, then followed by the implementation of
exec sp_addlogin 'appuser','163.com','TEST'
exec sp_grantdbaccess 'appuser'
If want to add the role of db_owner, so
exec sp_addrolemember 'db_owner', 'test'
Posted by Lena at November 18, 2016 - 5:41 AM
Posted by Marvin at November 24, 2016 - 6:20 AM