sql - 来自用户的REVOKE GRANT OPTION [英] sql - REVOKE GRANT OPTION from a user

问题描述

嗨。



我正在使用sql-server 2005;



有一个DB和一个名为myTB的表，

有两个用户名为user1和user2。



user2可以登录并设置一些权限例如，他可以执行以下查询：



对myTB拒绝权限对用户1。或授予权限......



现在的问题是我想限制user2！我的意思是user2不应该获得GRANT或REVOKE或DENY新权限的许可！



提前感谢。

Hi.

I''m using sql-server 2005;

there is a DB and a Table in it named myTB,
there are two users named user1 and user2.

user2 can log in and set some permissions, for example he can execute the query bellow:

DENY permission ON myTB TO user1. or GRANT permission ...

Now the problem is that I want to restrict user2 ! I mean that user2 shouldn''t have the permission to GRANT or REVOKE or DENY new permissions !

thanks in advance.

推荐答案

您好

Hi

GRANT <permission> [ ,...n ] ON 
    [ OBJECT :: ][ schema_name ]. object_name [ ( column [ ,...n ] ) ]
    TO <database_principal> [ ,...n ] 
    [ WITH GRANT OPTION ]
    [ AS <database_principal> ]

<permission> ::=
    ALL [ PRIVILEGES ] | permission [ ( column [ ,...n ] ) ]

<database_principal> ::= 
        Database_user 
    | Database_role 
    | Application_role 
    | Database_user_mapped_to_Windows_User 
    | Database_user_mapped_to_Windows_Group 
    | Database_user_mapped_to_certificate 
    | Database_user_mapped_to_asymmetric_key 
    | Database_user_with_no_login

不给[使用授权选项]，然后用户2不能授予用户1。



查看以下链接





SQL GRANT命令 [ ^ ]

在SQL Server中提供和删除权限 [ ^ ]





问候，

GVPrabu

Don''t Give [WITH GRANT OPTION] then user 2 can''t Give rights to user1.

Check the following link


SQL GRANT Command[^]
Giving and removing permissions in SQL Server[^]


Regards,
GVPrabu

谢谢。已解决：



使用myDB撤销授权选项从user2中选择

REVOKE privilege_name
ON object_name
FROM {user_name |PUBLIC |role_name}

这篇关于sql - 来自用户的REVOKE GRANT OPTION的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！