Permissions

Is there a way to give someone permission to create SP's, but not change any data?  Also, can I create a view if I only have read permissions?

Does anyone know of a good book on SQL permissions?  That would really helpful to me.
takia1977Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>Is there a way to give someone permission to create SP's,
grant the database role db_ddladmin

>but not change any data?  
you can try to use the DENY UPDATE to that login

>Also, can I create a view if I only have read permissions?
same as db_ddladmin
0
 
takia1977Author Commented:
Thanks for your help guys.  I am really new to this stuff.
0
All Courses

From novice to tech pro — start learning today.