Web Development

Ask something
Discussion Locked

SQL Server Security

0 helpful
5 replies

by ebartholom

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am a member of a small development team and we recently implemented a Performance Management system that stores employee performance appraisals online. Currently the three developers are in a dbo group for access to the SQL Server v.7 database in which the data resides. The Director would like us to not have access to each other?s appraisal records. Any solutions?

5 replies

by stillatit

The only sure way is to keep your three records off-line. Since the three of you are dbo's, you can change permissions, so locking you out of seeing stuff is reversable.

You could, of course, make a separate database, with the Director as the only dbo, with the identical structure and your records in it. This could work if none of you are admins, but it is a lot of work for very minimal gain.

Good luck.

by 3wadman

The easiest way is to add a extra column for each user to the table. ( AB, TJ, JB using their initals?)
Go into Column Permissions for the Table and grant select permissions for only that user's initial column.
Set a default check box in each record for each user based on their logon name. Run a SQL based on their column inital.

This discussion is closed to new replies.