hassan Posted April 2, 2018 Share Posted April 2, 2018 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 More sharing options...
Larry Posted April 2, 2018 Share Posted April 2, 2018 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 More sharing options...
hassan Posted April 2, 2018 Author Share Posted April 2, 2018 Many thanks I think I get what you mean that would be a level above operating at the raw database level. Link to comment Share on other sites More sharing options...
Recommended Posts