Search
 
SCRIPT & CODE EXAMPLE
 

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"

Comment

PREVIOUS NEXT
Code Example
Sql :: sqlcl format 
Sql :: row = 1 oracle sql 
Sql :: mysql view command does not work - privileges problem 
Sql :: run all sql file from folder postgres command line 
Sql :: join creating duplicate columns sqllite 
Sql :: procedure excute monthly oracle 
Sql :: get last 3 years data in mysql 
Sql :: how to change null display in psql 
Sql :: sql change date time from SGT to GMT 
Sql :: function sum(text) does not exist postgres 
Sql :: liquibase create table example 
Sql :: oracle pl/sql check if file exists 
Sql :: tsql For XML Path('), TYPE).value 
Sql :: mysql cannot access localhost 
Sql :: oracle APEX elapsed time 
Sql :: grouping function in mysql 
Sql :: sqdqsd 
Sql :: c# execute transact sql 
Sql :: select from diffrent tables 
Sql :: SQL Aliases with COUNT() 
Sql :: export partttion and import in oracle 
Sql :: is sql injection still possible 
Sql :: sql alchemy get last n elements 
Sql :: postgres call view 
Sql :: flexible search query delete table 
Sql :: sql saut de ligne 
Sql :: why mssql rds is using more than 95 memory pool 
Sql :: mysql configuration file storage location 
Sql :: oracle execute package dblink 
Sql :: custom row number 
ADD CONTENT
Topic
Content
Source link
Name
2+3 =