November 20, 2006 at 4:13 am
I manage a production sql server 2000 database on a windows 2000 server and have to give some developers (dbo) permissions on the sql database to alow them create and edit views in the database.I am not comfortable with this arrangement, because i beleive it gives them right to do other things within the database e.g editing the tables within the database.
Therefore, what is the best way to limit a users permission in sql server to just been able to have create and edit permissions on the views and therefore select permissions on the tables within the database.
vdavid
November 20, 2006 at 6:56 am
They don't even need to know the IP or the name of the server.
Build 'em a developpment server and grant them dbo there. You can grant 'em public on the dev machine if that can make them feel any better / or if they need to QA / debug the application.
November 21, 2006 at 8:28 am
I would not recomend giving DBO to any one. You can grant them explict permissions to be able to create views. This is done if you right click on the datbase name and then go to proprties\permissions. there you can grant create view to the users that need it. I would also think about making use of database roles and let the role be the owner of the view instead of a user owning it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply