How to add rights for user
Posted: Sat 19 Jan 2019, 11:55
1) Open SSMS
2) Connect in object explorer the database with sa account
3) Change in "Security tab - Logins - username to change rights - Properties - Securables" and add/remove rights
4) Re connect database with user which is your default user to connect the database
2) Connect in object explorer the database with sa account
3) Change in "Security tab - Logins - username to change rights - Properties - Securables" and add/remove rights
4) Re connect database with user which is your default user to connect the database