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

Answer Posted / satyajit patel

If u later want to change the password then go to the
database where the user is created and write

ALTER USER user_name IDENTIFIED BY new_password;

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it mandatory for the primary key to be given a value when a new record is inserted?

706


How does pl sql work?

520


What does bitemporal mean?

595


The select into statement is most often used to create backup copies of tables or for archiving records?

559


How is a PL/SQL code compiled?

666






What is the difference between partitioning and sharding?

523


How do I run a sql trace?

518


What is microsoft t sql?

489


What is an index in sql with example?

514


what is sub-query? : Transact sql

596


What is sqlerrd?

524


How to display Row Number with Records in Oracle SQL Plus?

590


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

666


how to drop an existing index in mysql? : Sql dba

533


What is bulk compiling in pl/sql.?

605