Assuming you are using windows authentication and you wish to only grant READ ONLY access, this should work: USE [master]
GO
CREATE LOGIN [DOMAIN\username] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
USE [DatabaseYouAreGrantingAccessTo]
GO
CREATE USER [DOMAIN\username] FOR LOGIN [DOMAIN\username]
GO
EXEC sp_addrolemember N'db_datareader', N'DOMAIN\username'
GO
GRANT SELECT TO [DOMAIN\username]
GO
GRANT SHOWPLAN TO [DOMAIN\username]
GO
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience