REVOKE command in PHP?

[Susan Gray]

Hello Guys,

I am beginner user in PHP so, I want some information about REVOKE command in PHP? Can anyone tell me?

 

[Steve Smith]

The REVOKE statement takes away permissions already Granted to users.When a user account is set up in SQL, in order for it to be able to do anything with the database, it must have permissions. These are given through the GRANT statement.

 

[herryprothyer]

Revoke command is used to remove granted privileges given to the user.
Syntax:-
Revoke privileges ON object FROM user_name
Example:-
To revoke the delete privilege on student table:
REVOKE delete ON student FROM XYZ