473,473 Members | 1,709 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Changeing the user name in oracle 9i

satishmovva
7 New Member
Hi Friends......

Is it possible to change (rename) the default user name in oracle 9i. If possible plz tell me how to change.

Waiting 4 ur valuable replies


With Regards

Satish Kumar. M
Jan 22 '07 #1
1 2220
nico5038
3,080 Recognized Expert Specialist
Make sure you have a new user with full granted access and then do a DROP USER username.

Nic;o)
Jan 23 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Praveen | last post by:
Hi All, I Created a Oracle user(schema) in my database. Now instead of droping the oracle user(schema), i want to inactivate it. Can anyone tell me how to inactivate the user instead of...
1
by: DC_DBA | last post by:
I want to 'grant sysdba to a user' for an application. (At least that is what I believe so far after having had this problem dumped on me 2 days ago.) The support we get from the application vendor...
2
by: John | last post by:
Hi, I have a data driven application which has some generalized components. So, for reuse, I am building the components so they can be reused in other projects ... it takes almost no extra...
5
by: dave71 | last post by:
Hi Could someone please advise me how to remove the schema name from linked tables within Access. For example when I connect to a Oracle database via Microsoft ODCB for Oracle the list of...
3
by: Leif | last post by:
I'm trying to set a parameter Value (see adddata below) from codebehind to a Java Applet. It looks good until I view the code in the Browser. (right click in Window). <APPLET height="140"...
6
by: Brian Henry | last post by:
Is it possible to change the database in which a crystalreports.net report is linking to? we have a bunch of reports made that pull straight form the database server, but work with differnet...
4
by: darkchild50 | last post by:
how would i go about makeing a program in python that asks for username and password and changes to that user?
1
by: Mikael Vehkajärvi | last post by:
Hello I am running ASP.NET (C#) using Oracle (PL/SQL, provider ODP.NET 11.1.0.6.20) and I have a procedure which at the moment returns a table of records. The code below demonstrates this. ...
1
by: BiffMaGriff | last post by:
Hello, I have a .net web app with an Oracle back end and I need to audit my database. I created this template trigger that I was using on inserts, edit & deletes however... "CREATE OR REPLACE...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.