August 24, 2011 at 2:56 pm
Is there a simple way to grant insert permission on a single table tbl1 in a database DB1 to all existing SQL Server Logins?
August 24, 2011 at 3:00 pm
yes, use a database role and grant users access to the role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 3:23 pm
PMar (8/24/2011)
Is there a simple way to grant insert permission on a single table tbl1 in a database DB1 to all existing SQL Server Logins?
This seems like a homework question. The solution is very simple, if you have any familiarity with permissions.
What role does every login in the server belong to? Once you've answered that, you'll know what to grant the insert permission to.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply