Friday, February 17, 2012

Create Views not Tables

I want to allow a group of users to create views but not be able to create new tables or stored procedures... how can I do this ??
Thanks, John :eek:See the GRANT (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ga-gz_8odw.asp) command in Transact-SQL.

-PatP

No comments:

Post a Comment