Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005 SQL-Server , +
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 21-Mar-13 0:58am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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
  Permalink  
Comments
rohit_singhk at 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)

  Print Answers RSS
0 BillWoodruff 360
1 Mathew Soji 309
2 DamithSL 225
3 Afzaal Ahmad Zeeshan 202
4 Maciej Los 190
0 OriginalGriff 6,249
1 Sergey Alexandrovich Kryukov 5,853
2 DamithSL 5,183
3 Manas Bhardwaj 4,673
4 Maciej Los 3,865


Advertise | Privacy | Mobile
Web04 | 2.8.1411019.1 | Last Updated 21 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100