Search
 
SCRIPT & CODE EXAMPLE
 

SQL

Sql creating roles

#Create a role
CREATE ROLE role1;

#Grant permissions on table to role
GRANT INSERT, SELECT, DELETE, UPDATE ON table1 TO role1;

#Create user and assign role
CREATE USER Bob;
GRANT role1 TO Bob;
Comment

PREVIOUS NEXT
Code Example
Sql :: sort by last three charecter in sql 
Sql :: sql drop table statement 
Sql :: power query concatenate 
Sql :: woocommerce mysql price table 
Sql :: copy one column data to another in sql 
Sql :: reset auto increment in mysql 
Sql :: mysql reset auto increment id 
Sql :: inner join php my admin 
Sql :: get table column names sql laravel 
Sql :: remove transient options sql wordpress 
Sql :: mysql delete 
Sql :: how to fetch alternate records from two tables 
Sql :: mysql all columns 
Sql :: create mysql user on all hosts 
Sql :: find logged in users mysql 
Sql :: oracle asynchronous procedure 
Sql :: centos 8 install mysql 
Sql :: add auto increment column mysql 
Sql :: can you use a where clause for a child query 
Sql :: XOR in SQL Server 
Sql :: mysql remove only_full_group_by permanently 
Sql :: sql display number without decimals 
Sql :: foreign key sqlite3 python 
Sql :: postgresql list users 
Sql :: convert rows to columns in sql server 
Sql :: allsource oracle 
Sql :: set nocount on sql 
Sql :: find duplicate keys in mysql 
Sql :: sql update table remove spaces 
Sql :: postgresql extract hour and minutes from timestamp 
ADD CONTENT
Topic
Content
Source link
Name
4+6 =