A USER HAVING CREATE SESSION PREVILAGE CAN ALTER
PASSWORD/CHANGE PASSWORD?
Answers were Sorted based on User's Feedback
Answer / harshada
No. The user can not reset or change the password. The user
is having only create session privileges. only SYS
DBA/manager can reset the password not a user.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / jimmy
no.the user can not change password . the user can create
and alter their own session privileges.
| Is This Answer Correct ? | 0 Yes | 0 No |
What operating systems are supported by oracle database 10g xe?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
Explain the difference between a procedure and a function?
What is a deadlock in SQL? How can you prevent it?
how do u know the total no of rows in a table?
waht is the difference between primary key and super key?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
what is index?
Explain cascading triggers.
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is raw datatype in oracle?
What is the purpose of a cluster?