how to create user in sql and how to set password for that?

Answer Posted / ayan banerjee

create user user_name identified by password

then

grant resource to user_name

grant create session to user_name

Is This Answer Correct ?    21 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List the different type of joins?

569


Is mariadb nosql?

581


what are enums used for in mysql? : Sql dba

608


Can we update views in sql?

531


What is embedded sql what are its advantages?

502






What is sql performance tuning?

492


Is oracle and sql same?

567


How to check if a column is nullable before setting to nullable?

580


What is a sql*loader control file?

615


How can you create an empty table from an existing table?

594


Is sql difficult?

743


How do you define a foreign key?

534


What is a left inner join?

533


Is time a data type in sql?

478


Can I create table without primary key?

527