Posts with the tag Database:

Assign Grant Priviliges to an User in MySQL

Assign Grant Priviliges to an User in MySQL Database

In this post, we will see how do we assign the Grant Privileges to a particular user, without which it is very difficult to assign a grant to an another user, and we need to always be dependent on the root user or the DBA.

Read More ...

Where Clause vs Having Clause in SQL

In this blog post, we will see the differences between the condition applied in the where clause and the having clause.

Read More ...

How to get the current time in MySQL

How to get the Current Server Time in MySQL

In this blog post, we will see how to get the current server time in the MySQL session.

Read More ...

How to get the Grant Details

How to get the Grant Details in MySQL

In this blog post, we will see how to get the privileges granted for a particular user, or the currently logged in user with the MySQL Database.

A proper way to verify the privileges granted or revoked to an user, is a good practice for all the authorization activities.

Read More ...

How to get the Current User Details

How to Get the Current User Details in MySQL

In this blog post, we will see the different ways we can get the currently logged in user in the MySQL Client inside the MySQL Session.

It is good to verify the currently logged in user details with the host name, for certain authentication and authorization purposes.

Read More ...