Click here to Skip to main content
14,836,169 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Dear Team,

Can you please explain how to restrict user from generating data base script ?

Deny permission to user for generating database script.


Regards
Rohit Kumar Singh
Posted
v2

1 solution

Hi,
Create a role and just give only view Definition for DB Objects (Table, Procedure ect..) Then they can't able to generate Script....
Check the following Links...
Granting View Definition Permission to a User or Role in SQL Server[^]
Grant permissions to view stored procedure text [^]
Regards,
GVPrabu
   
Comments
rohit_singhk 22-Mar-13 3:18am
   
Dear GVPrabhu,
I want to restrict Generate Database script for User or Global level.
Not to User Database restriction ,User can create Procedure,View Procedure,Create Table and view and acces all of thing but .
When he want to generate database script like database backup then user have not permission to generate database script.

Thank's

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900