Re: 3 Simple Security SQL Statements
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sat, 23 Jun 2007 17:20:21 +0000 (UTC)
Alex Maghen (AlexMaghen@xxxxxxxxxxxxxxxx) writes:
Hi. Can you please help me with three simple Transact SQL Statements
that do set up configurations? I'm having trouble with the specifics:
1. CREATE A USER "WebUser" in current database which uses a Windows Login,
"SERVER\IUSR_XYZ"
2. Give the above user "WebUser" ROLE membership in a database Role names
"WebUsersRole"
3. GRANT Execute permissions to the ROLE "WebUsersRole" for ALL Stored
Procedures in the database which start with the name "HM_"
I've been banging my head over this syntax for many hours and it's
making me NUTS! :)
And your professor was so mean that he did not give you hints where in
the manual you should look?
He did not even tell you which version of SQL Server you should use?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: Change Password Role
- Next by Date: Re: 3 Simple Security SQL Statements
- Previous by thread: Re: Change Password Role
- Next by thread: Re: 3 Simple Security SQL Statements
- Index(es):
Relevant Pages
|
|
