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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...