db_datareader role

Question

db_datareader role

prsnn_shetty

Right there with Babe

Points: 750
More actions
September 2, 2009 at 10:37 am

#209573

Hi,
I have assingned db_datareader role to windows user in sql2005
but the user is not able to view only system procedures.Is there
any way through which view defination role could be assinged to
user.
Regards
Prasanna

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Silverfox SSC-Insane Points: 23150 More actions · Answer 1

your question does not make sense, probably the reason noone has replied to you. can you explain again what you need help with?

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

ankur_libra Hall of Fame Points: 3999 More actions · Answer 2

Hi,

When only db_datareader role is assigned to any windows user in sql2005

that user is not able to view system procedures in that database.

You can grant view defination role that user as follows:-

grant view definition to username

Cheers:-)

Ankur

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

The db_datareader role allows for the use of SELECT against any table or view. It does not automatically allow a user to view the definition of a stored procedure. You need to grant VIEW DEFINITION on the schema or database level.

K. Brian Kelley
@kbriankelley