Only users with SYSADM or DBADM authority can grant and revoke these authorities.
只有具有SYSADM或DBADM权限的用户可以授予和撤消这些权限。
You must hold DBADM or SYSADM authority to grant or revoke the SELECT privilege on system catalog views.
必须要有DBADM或SYSADM权限,来授予或撤消系统编目视图上的SELECT权限。
The DBADM authority allows a user to perform administrative tasks on a specific database in an instance and allows full access to the data and objects in that database.
DBADM权限允许用户在一个实例中的特定数据库上执行管理任务,还允许完全访问这个数据库中的数据和对象。
If you hold CONTROL privilege on a table, you can update values that pertain to that table, but if you hold explicit DBADM authority on the database, you can change any updatable column.
如果在某个表上拥有CONTROL权限,那么就可以更新属于该表的值,但是如果拥有数据库上显式的DBADM授权的话,那么您可以更新任何可更新的列。
If you hold CONTROL privilege on a table, you can update values that pertain to that table, but if you hold explicit DBADM authority on the database, you can change any updatable column.
如果在某个表上拥有CONTROL权限,那么就可以更新属于该表的值,但是如果拥有数据库上显式的DBADM授权的话,那么您可以更新任何可更新的列。
应用推荐