Advertisement

06.12.2007 at 06:29AM PDT, ID: 22628230
[x]
Attachment Details

Oracle user creation

Asked by techprocess in Oracle 9.x, Oracle Database, Oracle HCM

Tags: oracle, user, creation

I want to create new user on existing SID but i don't have login information about the SYSDBA or owner of the database.

Is there any predefined login which has rights to create new user?

following is the script i will be using for creating user:

CREATE USER twofactor IDENTIFIED BY twofactor DEFAULT TABLESPACE  USERS TEMPORARY TABLESPACE TEMP;

grant connect to twofactor;
grant resource to twofactor;

connect twofactor/twofactor

thanx in advance.Start Free Trial
[+][-]06.12.2007 at 07:31AM PDT, ID: 19266434

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2007 at 07:38AM PDT, ID: 19266495

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 9.x, Oracle Database, Oracle HCM
Tags: oracle, user, creation
Sign Up Now!
Solution Provided By: nav_kum_v
Participating Experts: 4
Solution Grade: A
 
 
[+][-]06.12.2007 at 10:32AM PDT, ID: 19268140

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2007 at 09:50PM PDT, ID: 19272186

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.12.2007 at 11:53PM PDT, ID: 19272527

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2007 at 05:40AM PDT, ID: 19273920

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.05.2007 at 09:34AM PST, ID: 20217788

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.04.2008 at 08:23PM PDT, ID: 22157923

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]08.05.2008 at 07:31AM PDT, ID: 22161259

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.05.2008 at 07:55AM PDT, ID: 22161511

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.05.2008 at 08:33AM PDT, ID: 22161943

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.24.2008 at 06:25PM PDT, ID: 22302677

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]08.29.2008 at 07:27PM PDT, ID: 22350327

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32