Re: SQL Server Login

Create a LOGIN and map it to the database you want it to use.

Create a USER in that database for that login and grant it the necessary rights on that database such as following.

GRANT CREATE PROCEDURE TO [test_user]

GRANT SELECT TO [test_user]


You can learn more about these commands from the following links:

CREATE LOGIN (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms189751.aspx

GRANT (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms187965.aspx

--
Ekrem Önsoy



"Phil" <Phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FB92BAC6-F8B7-4BEF-A98E-388F39FC306E@xxxxxxxxxxxxxxxx
Hi,

I am after some advice for setting up a new Login on to my SQL Server, I
will be using a copy of SQL Server Express to connect to a SQL Server 2005
server running on a Windows Server 2003 machine.

I want to create a login which will be using Windows Authenticate to access
the server, once logged in, I only want the person to be able to see one
database and not all on the server and for them to only run SELECT
statements, if possible could they Create a Stored Procedure but only allow
that stored procedure to have SELECT statements in it, although not sure if
this bit is possible..

Thanks PD

P.S. If someone could point me in the right direction for some informative
web sites on how to create sql server logins it would be much appreciated.

.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)