When does grant statement take into effect

In both Sql Server and Oracle, permission changes to a user take into effect right away, even when said user is connected at the time you made the change.

In MySql, it is a little different, depending on how the permissions are given. If you use the GRANT statement, then it takes into effect right away. However, if you create user and give it permissions by manipulating the user table in the mysql system database directly, that is, using Sql statements, then you need to issue:

flush privileges

for those changes to be picked up.

1 Comment »

  1. The Ji Village News » Delete permission implementation differences Said,

    January 11, 2007 @

    […] I mentioned when grant statements take into effect in Sql Server, MySql, and Oracle here. […]

RSS feed for comments on this post · TrackBack URI

Leave a Comment