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 is the difference between SQL and SQL Server?
Select the Nth lowest value from a table?
What do you understand by a database object?
Explain how you would restore a database using RMAN to Point in Time?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
How to load data from external tables to regular tables?
Explain the use of online redo log files in oracle.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?