i 想要拒绝某个用户在数据库中查阅某些物体;但并非具体否认的是,如果存在违约,会允许使用。
通常要让用户成为<代码>db_ Owner/code>的角色,以便让用户能够进入(这是因为public
)。 自动滚动拖车可全部进入。 但是,如果在具体表格中具体拒绝<代码>电子表示<>/代码>许可,则这些用户仍可选择许可。
用户如何 除非
i 想要拒绝某个用户在数据库中查阅某些物体;但并非具体否认的是,如果存在违约,会允许使用。
通常要让用户成为<代码>db_ Owner/code>的角色,以便让用户能够进入(这是因为public
)。 自动滚动拖车可全部进入。 但是,如果在具体表格中具体拒绝<代码>电子表示<>/代码>许可,则这些用户仍可选择许可。
用户如何 除非
这一问题从来就没有被描述。
db_owner
fixed roleselect
access to a table这是因为用户首先采用一种观点、储存程序或功能。 很明显,如果你在桌旁听的话,你允许绕过安全。
发挥非主人作用的人,如db_datareader。 我认为,你的问题正试图拒绝挑选一位老板成员。 Same 前往行政。
I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...
In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user ...
I have been trying to execute a MS SQL Server stored procedure via JDBC today and have been unsuccessful thus far. The stored procedure has 1 input and 1 output parameter. With every combination I ...
Is it possible to use the sqlcmd command to dump table structure the way it can be done with mysqldump?
Hi I have the following SP, however when I use LINQ to SQL it generates 2 multiple recordsets. For my sanity I am trying to fathom out what it is in the stored procedure that is doing this and would ...
I want to create a table in MS SQL Server 2005 to record details of certain system operations. As you can see from the table design below, every column apart from Details is is non nullable. CREATE ...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...
How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8