1.

How Do We Rectify The Bove Error/ora:01045 Error?

Answer»

In order for a user to CONNECT and start communicating with the database ,he must be GRANTED CREATE SESSION system privilege.The following statement is USED:
SQL>GRANT CREATE SESSION to (username);
How to create a user with CONNECT system privilege?
SQL>GRANT CONNECT to (username) identified by (PASSWORD);

In order for a user to connect and start communicating with the database ,he must be granted CREATE SESSION system privilege.The following statement is used:
SQL>GRANT CREATE SESSION to (username);
How to create a user with CONNECT system privilege?
SQL>GRANT CONNECT to (username) identified by (password);


Discussion

No Comment Found

Related InterviewSolutions