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

Is big data nosql?

692


How many aggregate functions are available there in sql?

699


What are the types of index in sql?

771


What is procedure function?

707


Define concurrency control. : Transact sql

788






What is sqlite used for?

699


Is like operator in sql case sensitive?

730


What is a sql trace file?

740


Explain what is a view?

795


Which operator is used in query for pattern matching?

837


How do we use distinct statement? What is its use?

750


Define commit?

745


What is on delete restrict?

721


How do you copy a table in sql?

751


What are the differences between implicit and explicit cursors?

704