By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,473 Members | 1,274 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,473 IT Pros & Developers. It's quick & easy.

User Access Management Process exercise

P: 1
I know that users can be given permission to access the database to select data from database as shown below. But doing this for each user in the user table would take ages.. is there any method i could do this for all users in the user table

I want to give all of them roles to allow them to read certain tables only.. any ideas how this can be done.. but i dont want to do one user at a time i want to do the whole user table

CREATE LOGIN sam
WITH PASSWORD = '';
USE AdventureWorks;
CREATE USER sam FOR LOGIN sam;
GO
GRANT SELECT TO sam
Apr 5 '15 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,430
What have you tried so far?
Apr 6 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.