Users and permissions

[DougP]

SQL Server 7 and NT 4
If I assign a Domain "NT user" Administrative rights they can see the Data in an ODBC connection to our SQL server. This is done through Access 2000 using an ODBC DSN. Of course I don't want to do this for everyone.
Can you list the steps needed to allow any user to "Select", "Insert" "update" and "delete" data.

I would like to be able to just drag them into an NT group or maybe a SQL server Role.

BE specific.
TIA DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[JNC73]

Create user roles and assign that user to those roles you want him to have.

JNC73

 

[DougP]

Thanks for pointing me in the direction here is what I did.
--------------------------------------
Setting Up SQL Server Login permissions in a Database

This is for using NT authentication (NT users already setup in the Domain)
So you need to get the correct spelling of each user in User Manager for Domains.
Then it will get the user from NT when they log in and bingo they have permissions to the SQL server database too.

Open the Server Group and find the server to use
Click the “Security” location in the list below your server.

This will show 4 items:
Logins
Server Roles
Linked Servers
Remote Servers

Since The default roles are already in place.
go to Logins and open it.
You show see a few default logins (leave those alone)

Then Right click on the “Logins” and click “New Login…”
You should be on the “General” TAB (look at the very top of this dialog box)
In the Name box at the top, key in the NT User Domain name exactly.
Check the Windows NT Authentication box.
Pick the Domain from the drop down box.
In the Defaults (at the bottom) pick the Database you want them to default to:

Next at the top click the Database Access TAB
Put a check next to the database name (this is on the far left)
Then at the bottom choose the ”Role” I choose “Public” (put a check in it)
Then click the OK button and that’s it. For this portion.

Make sure the Role has permissions to the Tables you want to use.
----------------------------
Now then you need to make sure the public “Role” has the correct permissions for the database you want to use.
So under the database name which is back up the list a ways . “Universal” in our case click the ”Roles” section.
And you should see public listed there double click it.
Then click the Permssions button upper right
This will list all of the tables in that database
You can then check or uncheck permissions to each table and access like Select, Insert, Update, Delete, etc. by putting a check box in the column.




DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive