Block sensitive data fom dbo in SQL Server?

2007-11-27 9:24 am
Is it possible to make the tables with sensitive customer data not accessible from dbo role in SQL server?

Let say, create the SQL table by user role, and not let the dbo role to select data from it?

回答 (1)

2007-11-27 10:46 am
✔ 最佳答案
Like sa, dbo is the most powerful user in a database and no permissions can be denied to him.

dbo is a member of the db_owner database role, and these represent the equivalent of the sa/sysadmin pair at the database level.

Here's a query that can be used to find who is the owner of the current database:
select suser_sname(sid) from sys.database_principals where principal_id = user_id('dbo')

Hope this helps.


收錄日期: 2021-05-01 16:12:30
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071127012401AAtagJk

檢視 Wayback Machine 備份