creating login for read purposes only

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

creating login for read purposes only

Author

Topic

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2005-10-03 : 17:24:45

Hi friends

I want to create a login who has permission to read data only.
i created user and added role db_datareader.this is fine as user able to read data but i also want to give this user the ability to run few stored procs .how can i do that ??

Thanks

Cheers

Vivaldi
Constraint Violating Yak Guru

298 Posts

Posted - 2005-10-03 : 17:37:57

quote:
Originally posted by rajani

Hi friends

I want to create a login who has permission to read data only.
i created user and added role db_datareader.this is fine as user able to read data but i also want to give this user the ability to run few stored procs .how can i do that ??

Thanks

Cheers

you will have to explicitly grant them rights to execute the procs
Grant Execute on procname to username

________________________________________________

Working man's privilege, beer is.
Harsh, Life is.

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2005-10-04 : 15:46:22

Thanks for the post vivaldi.I managed to do that and its all fine.
BTW one more quick on this actually there are 3 options when assigning permission .ie. Grant,with Grant and Deny .what each of they mean.
at the moment i gave "Grant" permission for my user.
Thanks

Cheers

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-10-04 : 17:39:50

GRANT gives someone the specified permissions on the specified object.

WITH GRANT gives that user permission to GRANT permissions to others on that object.

DENY stops someone from using the specified permissions, even if they would have normally inherited GRANT permissions from another group or role.

REVOKE undoes a GRANT. It does not necessarily DENY permission, it just undoes the GRANT. Permissions revert to those of public or other groups/roles the user belongs to.

---------------------------
EmeraldCityDomains.com

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2005-10-04 : 17:53:32

Thats wonderful mate.
i got it now :)

Cheers

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources