Re: 3 Simple Security SQL Statements

Hi Alex

Actually, Erland did not tell you to read the manual. He did express
concern that you had not told us the version of SQL Server you expected
answers for, and you still haven't told us. Erland was also obliquely
expressing his assumption that these questions came from a class assignment,
not from a real business need.

Using these forums for help with homework, without telling us that it is a
homework exercise and that there is no real world environment to help
provide background, IS a very inappropriate use of this newsgroup.

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com


"Alex Maghen" <AlexMaghen@xxxxxxxxxxxxxxxx> wrote in message
news:EBCC71D4-3FB8-4D93-8CB0-C9BD28B1109C@xxxxxxxxxxxxxxxx
Erland -

Your response is an inapropriate use of this newsgroup. The answers to
*most* of the questions posted in these groups can be found in the
documentation. If I am posting the question here it is because I have
tried
to work through the documentation and I am still not succeeding.

If you do not wish to help others in these groups, no problem. Just please
do not respond with "Read the Manual."

Alex


"Erland Sommarskog" wrote:

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



.

Relevant Pages

  • Re: Licensing Question
    ... the database through one user account, ... are planning on using the "webuser" mssql account to achieve this ... David Portas, SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: 3 Simple Security SQL Statements
    ... CREATE A USER "WebUser" in current database which uses a Windows Login, ... He did not even tell you which version of SQL Server you should use? ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: getdate() in UDF
    ... Or it is classified as imprecise rather than non-deterministic? ... return from Erland) ... > Here noofyears is a computed column which tells us how long a person ... > SQL Server must materialize the values. ...
    (microsoft.public.sqlserver.programming)
  • Re: Adding Permissions on TEMPDB every time computer restarts
    ... >> The tempdb is created anew each restart of SQL Server using the Model ... >> database as its template. ... Can you just add the permissions to the Model ... > Erland Sommarskog, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Log Invalidated after truncate table
    ... * DUMP DATABASE ... * DUMP TRANSACTION ... In the same thread I found a statement from an SQL Server dev who said ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)