Answers for "sql create user and grant permission"

mysql add user with all privileges

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

Posted by: Guest on January-02-2020

sql create and grant user access to database

//oracle
sqlplus sys/<password> as sysdba
create user user1 identified by pass;
grant connect, resource to user1;
connect user1/pass;

Posted by: Guest on August-25-2021

Code answers related to "sql create user and grant permission"