Can I restrict Database Admins Access to the produ

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Can I restrict Database Admins Access to the produ

Author

Topic

Desineo
Starting Member

6 Posts

Posted - 2006-08-28 : 17:22:39

Hi All,

I have designed an application with MS Access front end and SQL Server 2000 backend. Is there a way by which I can limit the database Adminstrator's Access so that he is not able to modify the SQL server production database.

Thanks in advance!!!

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-08-28 : 17:44:13

No, not if he is in the sysadmin role on the SQL Server.

CODO ERGO SUM

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2006-08-28 : 17:44:32

NOT possible.

DavidM

Production is just another testing cycle

Desineo
Starting Member

6 Posts

Posted - 2006-08-28 : 17:57:23

Thanks..Any Ideas if there is a way to monitor his activities..I was thinking about triggers to tables, but then again he can go in and easily modify or disable them..any other ideas how I can moniter so that he cant make any unauthorized changes..

Thanks,

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2006-08-28 : 18:05:02

Desineo,

Have you heard the expression... "Press hard, there are 5 copies"

It simple means that you make him sign a document saying do not touch the DB...

DavidM

Production is just another testing cycle

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-08-28 : 18:07:15

Normally, it should be the other way around.

The Database Adminstrator should be making sure that you or soemone else is not making unauthorized changes to the database.

This sounds like a political issue, not a technical ossue.

CODO ERGO SUM

Desineo
Starting Member

6 Posts

Posted - 2006-08-28 : 18:12:38

thanks guys for all yr comments..I am an auditor..so I want to make sure..both sides(Admins and Users) are not making any unauthorized changes..

Thanks again for all yr help..

Regards,
Desineo

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2006-08-28 : 19:17:22

FYI

The latest version of SQL Server (2005) has the capacity to audit schema changes...

DavidM

Production is just another testing cycle

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources