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;

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;