Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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"

 
PREVIOUS NEXT
Tagged: #sql #dcl #queries
ADD COMMENT
Topic
Name
8+6 =