grant execute

Question

grant execute

newbieuser

SSCrazy Eights

Points: 9423
More actions
August 26, 2010 at 7:09 am

#237238

hi all,
I need some help with the grant permission.....After creating a user in the database, I believe the user should have connect access to the database. But the user will get the database objects access via an application role. For this user to execute this approle, does he need grant execute on application role?
Thank you so much..

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

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

Abhijit More SSCertifiable Points: 6897 More actions · Answer 1

Adding the user to database only grants conncet access, to specify any read/write or any other role sql has inbuild roles defined "Database Role" you can leverage this or else you can create your own role inheritted by database roles.

Abhijit - http://abhijitmore.wordpress.com

newbieuser SSCrazy Eights Points: 9423 More actions · Answer 2

Thanks.

But when I create a user in the database and login as that user I'm able to run execute the sp_setapprole without granting execute on the application role.. Will this work all the time or do I need to grant execute on application role to this user?

Thank you

pankushmehta Ten Centuries Points: 1217 More actions · Answer 3

Can you please provide a bit more of details. I am not sure if I understand it correctly.

ananthbhaskar Right there with Babe Points: 783 More actions · Answer 4

you might have given the user more permissions thn required , thats the reason you are able to execute the store proc,

please check the permissions at the server level as well as at the DB level, and post the clear question.