0

I am looking for a way to guarantee read and write permissions to my database to another user in my network.
I know Microsoft SQL Server Management lets my add users by right clicking on the user section here and filling this form.

Still, I am not sure what my Login name should be. For example, If I want to guarantee permission to the Administrator of a computer named GOR-PC, what should I enter?

Many Thanks.

MaayanCh
  • 1

2 Answers2

0

You should use GOR-PC\Administrator.

However, adding local users to your SQL Server is generally a bad idea. Ideally, you should use Active Directory users (in the form DomainName\UserName). This guarantees that the permissions you grant are independent of the existing of a PC or server.

Peter Elzinga
  • 406
  • 3
  • 12
-1

First you should create a user or group for the administrator on the server level that is under the general "Security" tab below the dabases: Security->Login->create. After tahat you can use the same login name you just created under the specific databse and Beowse the user and after that give the user read and write permission. Hope that helps.

Hankman3000
  • 115
  • 10