Jeff,
Developers should only have access to stuff
they need. This does not include SYS stuff. Basically, do you want
to be restoring the development database just because somebody was playing with
something? Further, who will be blamed for the developers not being able
to do their job while you are restoring the db - the developer who screwed it
up, or you?
I'm all for giving developers tons of privs
in the dev database - up to a point. You need to protect yourself from
them ruining your day.
To answer your question, I grant s,i,u,d to
the schema tables directly to the user to that they can create stored procs if
need be. I then migrate stored procs to the dev schema as need
be.
Hope this helps
Tom Mercadante
|
- Developer access in test database Jeffrey Beckstrom
- RE: Developer access in test database Jamadagni, Rajendra
- RE: Developer access in test database Mercadante, Thomas F
- RE: Developer access in test database Jeffrey Beckstrom
- RE: Developer access in test database Mercadante, Thomas F
- RE: Developer access in test database Kimberly Smith
- Re:RE: Developer access in test database dgoulet
- RE: Developer access in test database Deshpande, Kirti
- RE: RE: Developer access in test database Mercadante, Thomas F
- RE: Developer access in test database John Hallas
- Re: Developer access in test database Suzy Vordos
- Re: Developer access in test database Suzy Vordos
- RE: Developer access in test database DENNIS WILLIAMS