Re: User Question
Maurice @ ARS (maurice@xxxxxxxxxxxxxxxxxxxxxxxx) writes:
I am new to SQL and have a newbie question
Using OSQL how would I create a user that can access the DB with read
and write capabilities. I dont want the user to have SA capabilities but
be able to read and write to the DB.
Should that be an SQL login or Windows login? You use CREATE LOGIN for
that purpose, but since you did not say the type of login, I will have
to refer you to Books Online.
In the database run:
CREATE USER youruser
GRANT INSERT, SELECT, DELETE, INSERT TO youruser
--
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: SQL 2005 express blank sa passwords
... that uses the Sa login, I need to set the password to blank. ... I suggest that you get a voodoo doll of that former DBA, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security) - Re: Using sql to execute a batch file, xp_cmdshell
... In here I have entered the login and password for an accepted ... credential when I am running the bath file? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver) - Re: newbie Simple Question about Users in SQL 2000
... access with the roles public and db_owner for the database. ... I still get login failed for user d_xxxx. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver) - Re: sql express 2005 security
... If they can login, they can view the data, right? ... And, yes, this means that the user will be able to connect to the database ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security) - Re: SQL Profiler wont allow a developer to login
... group he can login to profiler. ... enabled through the Active Directory group which does give him sysadmin ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools) |
|
