Jump to content
Larry Ullman's Book Forums
Sign in to follow this  
hassan

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

Share this post


Link to post
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. 

Share this post


Link to post
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.

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...
Sign in to follow this  

×
×
  • Create New...