how to create user in sql and how to set password for that?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guruswamy
create user <username> IDENTIFIED BY password;
| Is This Answer Correct ? | 21 Yes | 6 No |
Answer / 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 |
Why is %isopen always false for an implicit cursor?
What is pl sql record in oracle?
How do you explain an index?
What is difference between inner join and cross join?
What is the difference between local variables and global variables?
who introduced sql?
How do you select unique values in sql?
Explain the types of joins in sql?
How much ram can sql express use?
How many functions are there in sql?
function can return multiple value?how give give sample coding
2 Answers 3i Infotech, CTS, Excelity Global, UHG,
How to get second highest salary from a table
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)