Subscribe Dialwebhosting Offers Subscribe to get exclusive offers directly in your inbox!
How To Assign Particular Permissions To Sql Server Database User From Sql Server Management Studio

How To Assign Particular Permissions To SQL Server Database User From SQL Server Management Studio?

SQL database users can be restricted to fire important queries through SQL server management studio. Queries related to deleting and updating are the usual ones fired by users. You can assign specific permissions to SQL server database users for accessing a table placed within the database. Follow these steps to ensure that the process is completed smoothly and successfully.

Log In To Your Account

The first step is to log in to the SQL server. This can be done through the SQL server management studio. The login details that you should follow to do it right are as follows:

When you log in to the SQL server, you will be prompted to enter the server type. Here, you must type database engine and enter the server name which of course, is the IP address. Connect after entering your username and password.

Choose The Desired Table

The next step is to select your SQL database and expand the database name. Choose the specific table within the database for which you want to assign the necessary permissions to the specific database user.

Step No. 3 is clicking on the table. Go to Properties, click and select permissions option from the dialog box where Table Properties is listed. The next step is to go to the search button and click on the tab which states Object Types. Check the Users option next and click OK. To select your SQL database user, click on the Browse button on the screen and choose the user. Click OK to complete the selection process.

To continue the process of assigning specific permissions to SQL server database user from SQL server management studio, go to Select Users or Roles dialog box and click the OK button again. Here, you can give the user the appropriate permissions.

Your Options - Windows Or SQL

A database user is based on a SQL login. This must be developed before you start the process. You can exercise the option of choosing from Windows authentication or SQL authentication while adding a SQL login. If you choose the former, you can select a local user, domain user or group account by browsing. Once you've created the login you can then grant that login access to a database which will create the user in the database.

When a user in the Administrators account attempts to run SQL Server Management Studio, the feature known as User Account Control takes away the membership token for that particular group. Further, it passes information only regarding the user account to SQL Server. A message is sent out which makes it clear that the account does not have the permission to log in to SQL Server. It is imperative that you clearly and explicitly add the account to the SQL Server logins to allow members of the that group to log in.

It is possible that at times, you will see some users, not associated with any logins. This happens because the database which has been included in another server might be restored here. It can also happen when the login has been deleted without deleting the users associated with it.

Was this answer helpful? #1 #0

Related Questions

Designed & Developed by Cyfuture India Private Limited