Has anyone worked out what permissions are required such
that a given database user can create, update and/or
delete stored procedures, but not do the same to
tables/views ?CREATE PROCEDURE permission is needed to modify SPs. CREATE VIEW is a
separate permission.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jim Trowbridge" <jtrowbridge@.adelaidebank.com.au> wrote in message
news:fd1001c40d60$e1f1acb0$a301280a@.phx.gbl...
> Has anyone worked out what permissions are required such
> that a given database user can create, update and/or
> delete stored procedures, but not do the same to
> tables/views ?
Showing posts with label ordelete. Show all posts
Showing posts with label ordelete. Show all posts
Friday, March 23, 2012
Permissions to allow updating stored procedures
Labels:
create,
database,
microsoft,
mysql,
oracle,
ordelete,
permissions,
procedures,
required,
server,
sql,
stored,
suchthat,
update,
updating,
user
Subscribe to:
Posts (Atom)