Showing posts with label permissions. Show all posts
Showing posts with label permissions. Show all posts

Friday, March 30, 2012

manage the stored procedure permissions....

hello all....can anyone tell me how can i manage the stored procedure permissions in SQL Server Express. Untill now i have developed in SQL Server 2000 and there i used SQL Enterprise Manager for this problem..in SQL Express i can't handle it...Manny thanks.....

hi,

for a graphic management tool, you can have a look at the Microsoft free provided one, you can get for free at http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

regards

|||

Thanks Andrea....but i have allready installed this tool...

in the mean time ....i've find the solution using that tool......go in the DB tree : Security-Users (choose the user that i want to add permisions) -Properties- Securables- here i add the objects and grant the permisions....

Manage Permissions Script

How can I create a script that will set all the permissions for a specific user for some objects in a database?
Thx in advance.How can I create a script that will set all the permissions for a specific user for some objects in a database?
Thx in advance.

What kind of permissions are you trying to set? Are you trying to copy permissions from an existing user? Or are you trying to grant specific privileges on all objects? Or specific privileges on specific objects?

Please amplify your question a bit.

Regards,

hmscott|||I want to grant (or not) someprivileges on specific objects.
I made something like that:
GRANT SELECT ON [dbo].[AGENT] TO [web]
GO
DENY UPDATE , INSERT , DELETE ON [dbo].[AGENT] TO [web] CASCADE
GO

Actually, my problem is that I have to deploy my stored procedures on another server where these settings should be set up.
But it looks when I made my export to that server I lost the grants for my user.
That's why I thought it will be nice to have a script that will make the job automatically.
Anyway, I should change the way I made the export because I have checked up the option "Drop destinaton objects first".