Finding Client Who Is Changing Schema Password

Mar 2, 2011

I want to send mail whenever the schema password is changed by the developers (clients) . I created this trigger to send mail. I am able to know which schema's password is changed but i want know how to get the client details who is changing the password.

Create Trigger Pwd_chg_trigger
before alter
on database
declare
begin
if (ora_dict_obj_type = 'USER') then
DBMS_OUTPUT.PUT_LINE(' ORA_DICT_OBJ_OWNER = ' || ORA_DICT_OBJ_NAME); -- to know which schema
-- using the above value and additional formatting i am sending the mail using my SMTP
end if;
end;
/

View 3 Replies


ADVERTISEMENT

Client Tools :: Changing DB Password Using SQLPlus Command Line

Jul 21, 2010

I'm trying to change a password. I can connect to the db then at the SQL prompt I'm using:

alter user <name> identified by <new password>

The dos window comes back with '2' - then just sits there

View 4 Replies View Related

Data Guard :: Changing Primary DB Password?

Dec 16, 2011

I've 2 DB : One primary and One physical standby. I want to change SYS password on primary DB. Can I do it without any action on standby DB side ? If not, give me a step by step details to perform this action properly.

View 4 Replies View Related

Data Guard :: Changing Password On Primary Database?

Nov 10, 2011

I'm using 2 databases : Primary and Standby DB. It working fine. I've just one question : I want to change SYS password on primary DB. Can I change it without any action on Standby DB?

View 8 Replies View Related

Application Express :: Creating Functionality For Changing Users Password

Mar 12, 2013

I'm trying to create a functionality on my application that lets the user change their password whenever they want or when the password gets expired.

But to do that, first I need a Branch to the page "Password Change" whenever the login procedure returns "Password Expire", but when the user has an expired password he can't access none of the pages of the application.

My other problem is:

Even if I can get the user to be redirect to the "Password Change" page, I would need a function that validate his current expired password, because in order to alter his own, he would need to inform his current password and the new one he desires. If I was using Apex Authentication that would be very easy I think, but I'm obligate to use Database Account Authentication.

View 4 Replies View Related

Changing Tablespace Of Schema

Oct 26, 2012

I have created my schema in SYSTEM schema way back accidentally by forgetting to specify the database tablespace. There is about 60 objects (tables, indexes, functions etc) and 6MB Of data.

What would be the best way migrate the schema to the tablespace I planned to put it into? .

View 7 Replies View Related

SQL & PL/SQL :: Finding User Who Made Changes In Table Structure Or Schema

Sep 21, 2011

i want to find the name of user who make changes in the table structure or create any index or constraint or unique key or alter the column? Is there any way to find in Oracle. in which table what change has been done as well?

following Output needed

userid, username, schemaname, schemachangetime, "what_change_has_been_made", IP address or Computername

View 11 Replies View Related

Client Tools :: How To Create A Table In Another Schema As In Existing Schema

Apr 26, 2010

I would like to create a table in another schema(CBF) as already exist in my schema(TLC) without data but related indexes,synonyms and grants should be include.

How could I do this without using export import. I am using TOAD 9.0.1.

View 10 Replies View Related

DBF File Size Changing After Cloning Same Schema From Different Machines In Oracle 11gR2

Jul 22, 2011

Our product uses Oracle11gR1 and in new release we are going to use Oracle11gR2. For this we are performing following steps:

(1) Install Oracle11gR2 on a machine where our product (Oracle11gR1) is already installed.
(2)Upgrade Oracle11gR1 schema to Oracle11gR2.
(3)For using upgraded schema in our product installer we create clone of upgraded schema.
(4)For creating clone we are using Oracle11gR2 DBCA utility.
(5) Clone files are successfully created (DBC, CTL, DBF).

Now we performed same steps from another machine and DBF file size changed very much. On one machine it was 89 MB and on second machine it was 150 MB. There is no different in schema and both machines are Windows 7 machines.

Tor educe size of schema we tried different space reclamation commands but size is not changing.

View 3 Replies View Related

Client Tools :: TOAD Not Finding Oracle 11g?

Jul 2, 2013

I am running TOAD 10.6 on Windows 7 (64-bit). I have two 64-bit Oracle 11g clients installed (all on the same machine). The first is Instant Client (client_1); the second is the Runtime client (client_2). The installation of Instant Client was a mistake, since it doesn't have a Network / Admin folder to drop a tnsnames.ora file into. The Runtime client is my desired client, which has the aforementioned folder that I subsequently dropped the file into.

On starting TOAD, it says that "No valid Oracle Client found. Please note that Toad only supports 32 bit Oracle Client installations". (This is odd, since my colleague is running the same Oracle Runtime client as me and has TOAD 11.6, and yet his is working fine. But, this is aside the point.) When, I click on the ellipsis button next to the "Connecting Using" field, TOAD says that I don't have any Oracle homes installed. I checked my registry key (via regedit) under Computer / HKEY_LOCAL_MACHINE / SOFTWARE / ORACLE. It looks like I have 2 Oracle homes (because of the 2 clients).

Also, I right-clicked on My Computer and brought up Properties, Advanced system settings, Environment Variables (on the Advanced tab). My PATH variable has both of my clients.

How to make my available clients (particularly, my client_2) show up in TOAD?

Here is what I have tried thus far:

-Alter the PATH variable to just have client_2. This didn't do anything.

-Try to uninstall client_1 and client_2 via:

a) There is a Universal Installer under Oracle Installation Products in my Runtime client. I do Deinstall Products, click on any of my Oracle homes, click on Remove, and a Warning window pops up saying to run a command at some location, but the location is truncated since I can't expand the window.

b) In my client_2, there is a deinstall Windows Batch File in the deinstall folder. When I run this, the command window sits there for a little bit, saying that some files were copied and that 1 directory was removed. It then closes on its own. This doesn't seem to do anything.

View 1 Replies View Related

PL/SQL :: User Session Has Expired And Enable User Without Changing The Password

Aug 13, 2012

User session has expired. I have to enable user without changing the password of the user.

View 1 Replies View Related

Server Administration :: How To See Schema User Password In Text

Oct 1, 2012

I need to see all schema users password in a text.I am database admin,but it difficult to remember the password of all users created in single database So we also dont want to change password of all time,table to view password in text. Also we all know we can see using dba_users, but it was showing in hash value i need it in a text

View 3 Replies View Related

Windows :: Changing JDK From Production Client?

Oct 20, 2011

I have been asked to create a new instance of an application server. As part of this, my management has asked me to replace any old JREs or JDKs.

We run 10g, so I installed the 10203_vista_w2k8_x86_production_client on my new server. I would like to replace the 1.4.2 JDK that is bundled with the Oracle Production Client with 1.6.0.

View 1 Replies View Related

Client Tools :: PL SQL Developer Program Changing Special Character

Mar 29, 2010

I dont know why, but my PL SQL Developer keeps changing special character as "ã", or "ç", to "?". And As I use these letters because of my language, I need a way to solve this thing.

View 6 Replies View Related

Client Tools :: Date Format And Calendar Type Are Not Changing In Oracle Form?

Oct 30, 2011

i have changed date's format and the calendar type in sqlplus through the following command so the date's format and the calender type both changed successfully and work, but in oracle form the they haven't changed.

alter session set nls_calendar='persian';

ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD';

ALTER SYSTEM SET NLS_DATE_FORMAT='YYYY/MM/DD' SCOPE=SPFILE;

Note: i know session would change the format temporally but i want to change it permanently so i tried alter_system but still no result

View 2 Replies View Related

Client Tools :: SQL Developer - Disable Save Password Functionality?

Feb 18, 2011

I want to install SQL Developer on a server but don't want the user to be able to store passwords by checking the "Save Password" box.

View 14 Replies View Related

Client Tools :: Not Able To Launch Sql Prompt After Entering Username And Password?

Oct 17, 2011

I have installed Oracle 10 galso changed the password of Scott,System users during installation via passwordmanagement. When I am click on sql plus icon to launch sql and entering user name : Scoot pwd :Tiger

It get closed and nothing is coming up.

View 7 Replies View Related

Application Express :: Changing Sequence In Content Frame Not Changing Ordering Of Regions

Apr 24, 2013

Using Application Express 4.2.1.00.08

Any problem using 4.2's One Level Tabs - Content Frame page where you have a parent region (of type content frame Body Container ) while number of child regions (of type Hide & Show Region - Borderless ), if you want to re-order them by changing the sequence, it has no effect when you run the page.

The regions still show in the same order top to bottom as it did before the update of sequences. Heading links (to show/hide child regons in content frames) has the same ordering as before.

View 3 Replies View Related

Client Tools :: Export Toad Saved Username Password And Import On Sqldevloper?

Jul 1, 2013

I want to use the saved Toad username password into SqlDeveloper. is there any way to use the same username password without recreating new connection to users.

View 3 Replies View Related

Client Tools :: ERD For Schema Using SQL Navigator

Oct 22, 2013

I am trying to create an erd for an existing schema and it has 91 tables and 6 views. An erd for all the tables and views is been requested but when i used the erd option, it asks me to select a file and asks how many levels of referential tables do you want to load? and the box by default shows 5. If i change or leave the no.5 alone and hit ok, and select one of the tables, it only shows an erd for about 6 to 8 tables connected. Whereas, the entire schema is connect with primary and foreign keys.

View 1 Replies View Related

Client Tools :: Dynamic Schema Name At Runtime

Nov 22, 2011

SRCDEV is my source scehma and TRGDEV is my target schema.

SRCDEV schema table data will be loaded into TRGDEV schema respective tables by applying certain business rules.

After loading SRCDEV tables to TRGDEV tables, i am trying to find eliminated rows in SRCDEV tables due to business rules applied.[requirement].

i am doing it in this way

(SRCDEV.table) minus (TRGDEV.table);

The problem here is my schema name will be changed in every environemnt. for example,

for DEV --> SRCDEV
for TST --> SRCTST
for PRD --> SRCPRD.

so i tried following; but it is not working.

how to solve this?

--SRCDEV SCHEMA -- SRC TABLE

CREATE TABLE SRC (SNO INT, PROD_CD VARCHAR2(100));

INSERT INTO SRC VALUES (1,'SOOO1');
INSERT INTO SRC VALUES (2,'S1OO1');
INSERT INTO SRC VALUES (3,'SO1O1');
INSERT INTO SRC VALUES (4,'SOO11');

[Code]...

IS THIS CORRECT SYNTAX?

View 1 Replies View Related

Client Tools :: Toad Schema Browser Multi Tabs

Jan 6, 2010

We are playing with Toad 9.7 and seems like the right tools for Trade. The schema browser on left hand side I am keeping on Multi Tab type.The one problem is that when I select Table or Constraint from there, the tabs rearrange and is quite annoying to find another tab say View again since it has changed its location.

Is there any way to keep the TABS fixed to their location so when you select no changing of their position occur.

View 3 Replies View Related

Server Utilities :: Import A Schema From One Database Schema To Another Schema B?

Aug 10, 2010

I want to import a schema from one database schema to another schema b from db STBTST to STATST and from schema CMSSTAGINGB to CMSSTAGINGA

I first want to test this to my own schema (mvanmannekes) CMSSTAGINGA is filled at the moment.

So i've created a dump from STBTST-CMSTAGINGB For importing im using this statement:

impdp mvanmannekes/password schemas=cmsstagingb remap_tablespace=cmsliveb_data:cmslivea_data
remap_tablespace=cmsliveb_index:cmslivea_index
remap_schema=cmsstagingb:mvanmannekes directory=expdp_dir dumpfile=cmstagingb.dmp

I'm getting this:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "MVANMANNEKES"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "MVANMANNEKES"."SYS_IMPORT_SCHEMA_01": mvanmannekes/********
schemas=cmsstagingb remap_tablespace=cmsliveb_data:cmslivea_data

[code]....

View 4 Replies View Related

How To Know Password (Exact Password Not Hascode) Of All Users As A Sysdba

May 28, 2008

How to know the password(Exact password not hascode) of all users as a sysdba in Oracle 9i or 10g.How to convert hashcode password to Actual password.

View 1 Replies View Related

SQL & PL/SQL :: Create Procedure That Will Send In Customer ID / Password And New Password

May 14, 2011

I am trying to create a procedure that will send in the customer id, password and new password. The procedure will say if it has been updated or not. this is the code i have.

--Patty Carson
--Assignment 3 Question 3
--Description: Allows the user to change a password for a customer
CREATE or REPLACE procedure ChgPwd
(custid OUT number, password OUT VARCHAR2, newpassword IN VARCHAR2)
AS
[code]...

View 15 Replies View Related

Security :: Create Password File / Don't Know Password Of Sys User

Jun 5, 2012

I want to know what if any person don't know the password of SYS, can he create password file, becauase i dont know the password of sys users, generally login with '/ as sysdba',

View 4 Replies View Related

Client Tools :: Grant User Schema To Another User

Feb 9, 2011

I have two users say A and B. I have all the tables,views,indexes, types,procedures,packages etc. User B wants to access all the objects from user A.

View 4 Replies View Related

Server Administration :: Accessing Single Schema From Multiple Schema Logging?

May 16, 2011

A single master schema where many developers are accessing. all share same password.

now i would like to trace all the changes made by each users. so i create a individual users for all and grant permission to access that schema.do i have a possibility of auditing the changes did by each user for that particular schema

View 2 Replies View Related

Security :: Schema Consolidation And User Schema Mapping Based On Service

Jul 24, 2011

We have an application with many separate databases (one per customer). Given they share the same business requirements (service hours, change mgmt etc), we're interested in potentially consolidating the separate DBs (which are relatively small) into separate schemas within a fewer no of databases to reduce the overhead.

Our issue is that the application is hard-coded to use a specific administrator and application connection user name. Changing this is unfortunately not an option.

Given this limitation, is there any possibility to map a generic user into a customer-specific schema based on the database service that they connect to? Each customer connects to different database services but may use the same user name. We considered using private synonyms but this seems to acheive the opposite (i.e. many different users could connect and map to a single users schema). One thing to point out is that where there is a single user name, it is acceptable for a single password to be used across the different customer DBs as they will be a single admin/user.

View 5 Replies View Related

Server Utilities :: How To Take All Schema Metadata Export Except One Schema (scott)

Jul 5, 2012

how to take all schema metadata export except one schema (scott)

can i use like EXCLUDE=schema:"IN('SCOTT')

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved