grant user 'select' permissions - sql 2008

You can play with windows and sql authentications from "Security" -> "Logins"

You can add a new windows authentication and, from properties, assign it to a determinate database role or specify the exact permissions you want to assign to it.

In SQL Management Studio, right click on the DB, go to properties.  Then go to permissions, add the username or role and check grant on "select".

Try this:

CREATE LOGIN <name of Windows User> FROM WINDOWS
GO
USE <yourdbname>
GO
CREATE USER <user name> FOR LOGIN <login name>
GO
EXEC sp_addrolemember db_datareader, <user name>
GO

Select allOpen in new window

follow the above post and add "db_dataread" role to the win auth user.

Open SSMS, on the explorer window, expand Security, right-click on user and select add new user.

Select Windows Authentication mode and add new user DomainName\Username

Once you have done this code:

GRANT SELECT ON [tableName] TO [user]

Hope this helps

CREATE LOGIN domain\user FROM WINDOWS
GO
USE xxLL1_Production
GO
CREATE USER domain\user FOR LOGIN domain\user
GO
EXEC sp_addrolemember db_datareader, domain\user
GO

throwing errors at the \
at first i didnt have the \ and it complained about needing domain

i like @sammySeltzer approach

i'm logged in as sa and added the domain user to security>logins

GRANT SELECT ON xxLL1_Production TO user

returns

Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'xxLL1_Production', because it does not exist or you do not have permission.

Try this...

use master
go

--Groupe pour les accès en lecture sur les bases VMAT
if not exists (select name from syslogins where name = 'YOURDOMAIN\YOURLOGIN')
begin
	create login [YOURDOMAIN\YOURLOGIN] from windows;
end

use [YOURDB]
go

if not exists (select 1 from sysusers where name = 'YOURDOMAIN\YOURLOGIN')
     begin
	CREATE USER [YOURDOMAIN\YOURLOGIN] FOR LOGIN [YOURDOMAIN\YOURLOGIN];
     end

Select allOpen in new window

use mydb
go

exec sp_addrolemember db_datareader, MYUSER
go
exec sp_addrolemember db_datawriter , MYUSER
go

GRANT SELECT ON dbo.xxLL1_Production TO user

GRANT SELECT ON dbo.xxLL1_Production TO jdoe

Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'xxLL1_Production', because it does not exist or you do not have permission.


logged in as sa
user exists under security>logins

not have elite dba skillz so these other solutions are over my head.  much love.

If xxLL1_Production is database and jdoe is a login:

USE xxLL1_Production
GO
CREATE USER jdoe FOR LOGIN jdoe
GO
EXEC sp_addrolemember db_datareader, jdoe
GO

Select allOpen in new window

@daniel, this is the output

Msg 15007, Level 16, State 1, Line 1
'jdoe' is not a valid login or you do not have permission.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 75
User or role 'jdoe' does not exist in this database.

oops forgot the read priviledge...please run this

hope htis helps

use master
go

if not exists (select name from syslogins where name = 'YOURDOMAIN\YOURLOGIN')
begin
	create login [YOURDOMAIN\YOURLOGIN] from windows;
end

use [YOURDB]
go

if not exists (select 1 from sysusers where name = 'YOURDOMAIN\YOURLOGIN')
     begin
	CREATE USER [YOURDOMAIN\YOURLOGIN] FOR LOGIN [YOURDOMAIN\YOURLOGIN];
     end

exec sp_addrolemember N'db_datareader', N'YOURDOMAIN\YOURLOGIN'
go

Select allOpen in new window