Re: 3 Simple Security SQL Statements

Okay, let's take a deep breath. First of all, sorry if I overreacted. Just
really didn't like the tone. Second, SQL Server 2005. Third, oh, my friends,
if *only* I were still in school! :) It may *sound* like a class question,
but it is, in reality, something I need in order to simply the process of
publishing an entire database file from one system to another on a repeated
basis during the development cycle. Each time I do, I need to reset a bunch
of settings that it is impossible for me to have in place on the development
machine, but which are required on the staging server. Until now I have been
doing this all manually in the Management Studio and it's making me nuts.

And, onbliquely or not, he *did*, in fact, tell me to read the manual. :)

Alex


"Kalen Delaney" wrote:

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: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)