84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
In SQL, the command to revoke user operation permissions is REVOKE, and its syntax is as follows: REVOKE [GRANT OPTION FOR] ONFROM . Permissions can be SELECT, INSERT, UPDATE, DELETE, CREATE, or DROP. The object can be a table, view, or procedure. Only users with administrator rights can reclaim the rights of other users. The command to revoke user operation permissions in SQL In SQL, the command to revoke user operation permissions isREVOKE. Use REVOKE command REVOKEThe syntax of the command is as follows: REVOKE [GRANT OPTION FOR] <权限> ON <对象> FROM <用户> Copy after login Among them: [GRANT OPTION FOR]: Optional parameter, specifying whether to also recycle options for granting permissions. : The permission to be reclaimed can be one of the following: SELECT INSERT UPDATE DELETE CREATE DROP ##: The object to be revoked, which can be a table, view or procedure . : The user whose permissions are to be revoked. ExampleThe following example recycles useruser1'sSELECTon tabletable1Permissions: REVOKE SELECT ON table1 FROM user1; Copy after login The following example revokes all permissions from useruser2to viewview1, including granting permissions: REVOKE ALL PRIVILEGES ON view1 FROM user2; Copy after login Notes Only users with administrator rights can reclaim the rights of other users. If the user has multiple permissions on the object, the REVOKEcommand will only revoke the specified permissions. To reclaim all privileges, useALL PRIVILEGES.Options granted permission can only be reclaimed by the user who granted the permission. The above is the detailed content of The command to reclaim user operation permissions in sql is. For more information, please follow other related articles on the PHP Chinese website! source：php.cn Previous article：What does null mean in sql Next article：What are the aggregate functions in sql Statement of this Website The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn Latest Articles by Author How to convert to string type in js 2024-05-10 05:00:26 The relationship between objects and classes in js 2024-05-10 04:57:21 What are the objects in js 2024-05-10 04:54:17 Which methods in js will change the original array 2024-05-10 04:51:19 Usage of class in js 2024-05-10 04:45:28 Advantages and disadvantages of closures in js 2024-05-10 04:39:16 Actual usage scenarios of classes in js 2024-05-10 04:33:20 The role of document.createlement in js 2024-05-10 04:30:23 What are the methods of document in js 2024-05-10 04:27:19 How to use document in js 2024-05-10 04:24:18 Latest Issues function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function... From 2024-04-29 11:01:01 0 1 935 How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version? From 2024-04-23 00:22:19 0 9 1010 The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented. From 2024-04-19 15:37:47 0 1 926 There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ... From 2024-04-18 23:52:34 0 0 786 Where is the courseware about CSS mind mapping? Courseware From 2024-04-16 10:10:18 0 0 867 Related Topics More> what does facebook mean How to solve 0xc000035 How to install wordpress after downloading it What are the Linux shutdown commands? What are the image processing software How to change ip address in linux How to use panel control Solution to failed connection between wsus and Microsoft server Popular Recommendations What are the SQL delete statements? Usage of Case When in SQL What is the order of execution of sql statements? What are the commonly used relational databases? How to set foreign keys in database sql statement Popular Tutorials More> Related Tutorials Popular Recommendations Latest courses The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course) 1394913 PHP introductory tutorial one: Learn PHP in one week 4206621 JAVA Beginner's Video Tutorial 2350918 Little Turtle's zero-based introduction to learning Python video tutorial 493319 PHP zero-based introductory tutorial 826317 The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course) 1394913 times of learning JAVA Beginner's Video Tutorial 2350918 times of learning Little Turtle's zero-based introduction to learning Python video tutorial 493319 times of learning Quick introduction to web front-end development 213417 times of learning Master PS video tutorials from scratch 843264 times of learning [Web front-end] Node.js quick start 3149 times of learning Complete collection of foreign web development full-stack courses 2544 times of learning Go language practical GraphQL 1989 times of learning 550W fan master learns JavaScript from scratch step by step 465 times of learning Python master Mosh, a beginner with zero basic knowledge can get started in 6 hours 10893 times of learning Latest Downloads More> Web Effects Website Source Code Website Materials Front End Template [form button] jQuery enterprise message form contact code [Player special effects] HTML5 MP3 music box playback effects [Menu navigation] HTML5 cool particle animation navigation menu special effects [form button] jQuery visual form drag and drop editing code [Player special effects] VUE.JS imitation Kugou music player code [html5 special effects] Classic html5 pushing box game [Picture special effects] jQuery scrolling to add or reduce image effects [Photo album effects] CSS3 personal album cover hover zoom effect [Front-end template] Home Decor Cleaning and Repair Service Company Website Template [Front-end template] Fresh color personal resume guide page template [Front-end template] Designer Creative Job Resume Web Template [Front-end template] Modern engineering construction company website template [Front-end template] Responsive HTML5 template for educational service institutions [Front-end template] Online e-book store mall website template [Front-end template] IT technology solves Internet company website template [Front-end template] Purple style foreign exchange trading service website template [PNG material] Cute summer elements vector material (EPS PNG) [PNG material] Four red 2023 graduation badges vector material (AI EPS PNG) [banner picture] Singing bird and cart filled with flowers design spring banner vector material (AI EPS) [PNG material] Golden graduation cap vector material (EPS PNG) [PNG material] Black and white style mountain icon vector material (EPS PNG) [PNG material] Superhero silhouette vector material (EPS PNG) with different color cloaks and different poses [banner picture] Flat style Arbor Day banner vector material (AI+EPS) [PNG material] Nine comic-style exploding chat bubbles vector material (EPS+PNG) [Front-end template] Home Decor Cleaning and Repair Service Company Website Template [Front-end template] Fresh color personal resume guide page template [Front-end template] Designer Creative Job Resume Web Template [Front-end template] Modern engineering construction company website template [Front-end template] Responsive HTML5 template for educational service institutions [Front-end template] Online e-book store mall website template [Front-end template] IT technology solves Internet company website template [Front-end template] Purple style foreign exchange trading service website template About us Disclaimer Sitemap php.cn：Public welfare online PHP training，Help PHP learners grow quickly！
The command to revoke user operation permissions in SQL
In SQL, the command to revoke user operation permissions isREVOKE.
Use REVOKE command
REVOKEThe syntax of the command is as follows:
REVOKE
REVOKE [GRANT OPTION FOR] <权限> ON <对象> FROM <用户>
Among them:
[GRANT OPTION FOR]
: The permission to be reclaimed can be one of the following:
SELECT
INSERT
UPDATE
DELETE
CREATE
DROP
: The object to be revoked, which can be a table, view or procedure .
: The user whose permissions are to be revoked.
Example
user1'sSELECTon tabletable1Permissions:
's
on table
Permissions:
REVOKE SELECT ON table1 FROM user1;
user2to viewview1, including granting permissions:
to view
, including granting permissions:
REVOKE ALL PRIVILEGES ON view1 FROM user2;
Notes
command will only revoke the specified permissions. To reclaim all privileges, use
.
The above is the detailed content of The command to reclaim user operation permissions in sql is. For more information, please follow other related articles on the PHP Chinese website!
