Re: Network Admins vs. Sql Progammers
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Normally they just need dbo rights on the database, if ysou want them
to create databases on their own you additionally have to place them in
the database creator role on server level. That should be enough if you
want to tighten up the security.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
.
Relevant Pages
- Stopping logins making schema changes
... We have a server that contains one 20Gb database and, unfortunately, the ... application that connects to it has to have DBO rights or no rights at ... they've started adding DTS packages to the server. ...
(microsoft.public.sqlserver.security) - Re: Windows Authentication
... Can you try the below from query Anlayzer: ... use <dbname> ... sp_addrolemember 'db_owner','dbusername' -- THis is database wide role ... > I would like to give a user dbo rights to a few ...
(microsoft.public.sqlserver.security) - How to execute SP_ADDUSER without DBO Priv.
... requires to add SQL users to an application database. ... only way to do this is to run the store proc sp_adduser. ... do NOT want the application user to log on with dbo rights. ...
(microsoft.public.sqlserver.security) - Multiple Database name query
... I need to generate a script to return the database name for all databases ... the current user has dbo rights? ... I am tryint to user a select statement ...
(microsoft.public.sqlserver.programming) - Re: Table permissions
... >> HTH, Jens Suessmeyer. ... >>> I have a problem with a database with more than 100 tables. ... >>> grant ALL theese permissions to ALL the tables in a database at a time. ...
(microsoft.public.sqlserver.msde) |
|
