Click here to Skip to main content
13,056,229 members (72,542 online)
Rate this:
Please Sign up or sign in to vote.
Dear Team,

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

Deny permission to user for generating database script.

Rohit Kumar Singh
Posted 20-Mar-13 23:58pm

1 solution

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

Solution 1

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 [^]
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.


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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170728.5 | Last Updated 21 Mar 2013
Copyright © CodeProject, 1999-2017
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