Answers for "sql dcl queries"

1

sql dcl queries

# user list
select user from mysql.user

# add permission to user 
grant <priveledge> on <table_name> to <user>

example : 
grant select on std to "Akash"


# create user
create user "username"@"localhost" identified by "password"

# show user permission
show grant for "username"@"localhost"
Posted by: Guest on June-07-2021

Browse Popular Code Answers by Language