Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 prevent stored proc/view creation

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2015-01-05 : 11:51:15
Hello,
How is it possible to prevent a user from altering and creating a stored procedure or view?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-05 : 12:07:31
DENY CREATE PROCEDURE TO <user>;
DENY ALTER PROCEDURE TO <user>;
DENY CREATE VIEW TO <user>;
DENY ALTER VIEW TO <user>;
Go to Top of Page
   

- Advertisement -