Jump to content
Larry Ullman's Book Forums

Mysql Drop And Revoke


Recommended Posts

Hi 

 

On page 645 the second tip mentions the DROP command and the REVOKE command.

 

Would I be correct in assuming that:

 

1) We will use a DROP command for example if users wished to complete remove/close his or her account. 

 

2) We will use REVOKE command for example when a users subscription ends so that we may remove read access to some paid for information

Link to comment
Share on other sites

Good questions! Not exactly, these refer to permissions for MySQL users. Unless you're running a hosting company, you're not giving your users direct access to MySQL. 

 

What you're talking about would all be represented by stored data. For example, you might have an "active" column in a record for a user that reflects if the account is open or not. 

Link to comment
Share on other sites

 Share

×
×
  • Create New...