How to restrict SA of SQl Server

SANCHIT SHARMA

Active member
Joined
Jul 15, 2005
Messages
38
Programming Experience
10+
We created a database, with a new owner "AA" and Password "BB". While we create any table ,view or any procedure it gets prefixed with dbo...
This feature makes it public in nature.. our requirement is

The table we created with owner "AA" and password "BB" should only be handled by user AA for all administrative work.

We want only our application to access the database and the user should not be able to access our database tables if he tries to access the data with a sa (system administrator) log in. Kindly help us.

How to overcome this situation , Pls. Help

Regards
 
Back
Top