SQL & PL/SQL :: How To Know Particular User Existed Or Not In Database
Apr 22, 2013May i want to know SQL command to find particular table name in a particular user account existed or not in oracle 11g database
View 8 Replies
ADVERTISEMENT
Oracle Database 11g Accepts DBA Login For Not Existed User?
Oct 24, 2012I have Installed Oracle database 11g, By mistake I logged as :
mm/mm@orcl as sysdba
The Database acctepted the login with a full DBA privillages, although this user is not created within the database users.
SQL & PL/SQL :: Partition On Existed Table
Aug 14, 2010How can we partition the existed table.
below scenario.
CREATE TABLE table_partition(sales number,year date,item char(4))
partition by range(year)
(
PARTITION p1 VALUES LESS THAN 1980,
PARTITION p2 VALUES LESS THAN 1982,
PARTITION p3 VALUES LESS THAN 1985
);
The above code will create table with partition.
That is the table is not existed before we are creating table with partition.
But my requirement is the table is already existed with 100000 rows.Now I want to range partition that table.
SQL & PL/SQL :: Partition Existed Table Into 3 Partitions
Mar 9, 2010How can we partition the existed table.
The table is like this
CREATE TABLE my_table (
id NUMBER,
description VARCHAR2(50)
);
[Code]...
I want to partition this table into 3 partitions.
The first partition should contain the values less than 3.
The Second partition should contain the values less than 5.
The third partition should contain the values less than 6.
SQL & PL/SQL :: Display Rows Existed In T_SOURCE Table?
Jul 2, 2010How can we display the rows which are existed in T_SOURCE table and which doesn't existed in T_TARGET table using outer join.
My code is as follows.
CREATE TABLE T_SOURCE(sno NUMBER,sname VARCHAR2(20));
CREATE TABLE T_TARGET(sno NUMBER,sname VARCHAR2(20));
INSERT INTO T_SOURCE VALUES(1,'A');
INSERT INTO T_SOURCE VALUES(2,'B');
INSERT INTO T_SOURCE VALUES(3,'C');
INSERT INTO T_SOURCE VALUES(4,'D');
INSERT INTO T_SOURCE VALUES(4,'E');
INSERT INTO T_TARGET VALUES(1,'A');
INSERT INTO T_TARGET VALUES(2,'B');
I tried this but I am getteing all the rows.
select t_source.sno,t_source.sname
FROM t_target,t_source
WHERE t_target.sno(+)=t_source.sno
AND
t_target.sname(+)=t_source.sname
PL/SQL :: Create Trigger To Insert Data From One User To Another User In Same Database?
Apr 16, 2013I Created One Trigger as Follows
CREATE OR REPLACE TRIGGER TRIGGER1
BEFORE INSERT
ON table1
FOR EACH ROW
[code]......
Here , I Want To Insert The Data From My User To Test User . In This Situation When I Execute The Above Trigger It Shows The Error PL/SQL: ORA-00942: table or view does not exist
Security :: To See Any Database For The Operations Of Sys User Or Any Other User
Aug 23, 2011I have enabled Auditing in my oracle Database but I am not able to see any database for the operations of sys user or any other user in my "SYS.AUD$" and "SYS.FGA_LOG$" tables.
Value for the parameter "AUDIT_TRAIL" is set to "db,extended".
I am working as "SYS" user and I have shutdown and again startup the database but neither there was any information in both the tables nor I can see any files at the destination specified by "AUDIT_FILE_DEST".
Find Youngest User In Database?
Feb 6, 2007How do you find the youngest user in a certain table
select a.illness_desc
from uma.pc_illness a, uma.pc_patient b, uma.pc_diagnosis c
where b.patient_no = c.patient_no and c.illness_code = a.illness_code
and b.age = '21';
i currently have this (it also needs to display their illness which i have done) but i can do only if i cheat and see what the youngest user is, so instead of b.age = 21 i need something that will search the database and find that youngest age
we are using SQL+
SQL & PL/SQL :: User Restriction On Database Level?
Dec 13, 2011For the list of userid's, how to find the list of OS/Restricted Shell ID's at the database level ?
View 7 Replies View RelatedSQL & PL/SQL :: Extract DDL Of Constraints Of User In Database?
Feb 10, 2012How to extract the ddl of constraints of a user in a database?
View 6 Replies View RelatedPL/SQL :: Unlock Oracle Database User?
Jun 14, 2013Could the Oracle database user be configured so that it will not get locked with infinite wrong tries.
View 3 Replies View RelatedReplicate User In Oracle Database
Jan 31, 2013I Have one oracle user ABC which is having 10 Tables.
Now i want to create replica of this user XyZ which can access only 5 tables from . This user having All access.
Example :
Any DML changes made in XYZ these changes should be reflected in ABC user. and vice a versa.
How can i achive this in ORACLE DB.
Security :: How To Find Current User In Database
Sep 22, 2011query to find the current user accessing the database
View 5 Replies View RelatedServer Administration :: Connect 9i To 10g With Same Database And User?
Oct 19, 2012last two years i am using oracle 9i in windows 2003 server but now i installed oracle 10g on another server (PC) , i want to connect 9i to 10g with same database and user .
View 3 Replies View RelatedServer Utilities :: Clone Database User
Aug 1, 2011I want to create such a script to clone the Database user with the new name. Just like we do normal import and export I want that i should enter just the username of the existing user and username of the new user I want to get created, the password for the same.
It should create the new user with all roles and the default roles and privileges of old user.
Access Oracle Database From Root User?
Dec 18, 2012i have an linux instance running oracle 11g as oracle OS user. i am able to connect the DB from clients.
i need to access this DB from OS root user. what should i do.
Trace Particular One User SQL Activity In Oracle 10G Database?
Jan 27, 2013I want to trace particular one user SQL activity in Oracle 10G database.
Note - Not only one session / Not for all Database activity
Database User Account Lock And Expire
Jun 28, 2012I have altered an user account and set the account status as expired.When I tried to connect with that user, oracle prompted for changing password.
But, after I changed the password, I got an error message as ora-01017 invalid username/password logon denied password unchangedWhat is the cause and solution for it? I am using 11g database and 10g client.
Security :: Find Out The User Access The Database?
Nov 8, 2011Is there a way to find out the user access the database?
View 1 Replies View RelatedMaximum Number Of Processes Per Database User
Jun 1, 2013I am using Oracle 11g R2. (11.2.0.3)
I know that in the profiles of the user I can set limit for the number of sessions per database user, using the below command:
alter profile <profile_name> limit sessions_per_user=<required_number>;
I need to set maximum number of processes for the application user so in case they opened too many number of processes on the database they do not block the automated jobs to be run.My questions:
1. set a limit on sessions_per_user is it the same as a limit on processes? 1 proccess= 1 session ? Is there any way to limit the number of processes (not sessions) for a database user?
2. I am using RAC so the number of sessions is per the whole database, while the max number of processes is by instance (not database), so even I set a limit on the number of sessions (above the limit of processes for one of the instances) one instance may face ORA-20 errors, while the max number of sessions did not hit the limit. is there any workaround for this case?
How To Find Length Of User Account Password In A Database
Jun 13, 2013how to find length of the user account password in a database?
View 1 Replies View RelatedSecurity :: How To Find User And IP Address From Oracle Database
Jun 19, 2013Last week we have realized that a user who connects through SQL Developer(as nothing wrong found in application server logs) has made a serious change in the database which created a real mess. The user has done some mischief in some calculations by making some inserts and updates in some important tables in our production database.
How can I find which user or from which IP the change is made.
Forms :: Connecting To Other Database User Inside A Form
Mar 8, 2012I have a problem concerning change of the connection inside a form. I have this code in when validate item trigger
LOGOUT ;
LOGON ('FIFES_HN','FIFES_HN@PRD_253');
MESSAGE (GET_APPLICATION_PROPERTY(USERNAME));
MESSAGE (GET_APPLICATION_PROPERTY(USERNAME));
MESSAGE (:DAILY_TRX_CONT.ORG_ID);
[code].........
how the last message is 'FIFES_HN' it show be 'SIFESD'
Restrict User To Login On Primary Database Using Discoverer
Dec 14, 2012We are using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 and Oracle Discoverer 9i desktop & Administrator,We have configured a physical standby database. We have ask users to connect to standby thru discoverer thru a different tns entry, but user can also connect on primary db.
We want to restrict the specified users to connect on primary database thru discoverer.
Security :: Lock User Accounts In Oracle Database
Jul 12, 2011I have a doubt in locking user account in oracle database.I was told to drop some unusable users in database which my clients dont require them.I verified the dependent objects of those users but not sure if these users can be dropped.
Instead can i make those user accounts locked so that they cannot connect to database? Would there be any impact on database performance if i lock those user accounts?
Is locking an account and dropping users is similar in anyway?
Security :: Audit User Connection On Reporting Database?
Jun 9, 2011I want to audit user connection on my reporting database, and send a report to application team on monthly basis, with a list of users who are not connected for a month and remove them.
What would be best method, i know there is LOGON trigger, or database level auditing.
Forms :: Enable User To Select And Save Any Document Into Database?
Dec 6, 2012how can i enable user to select and save any document into oracle database and later on choose to retrieve and display it.it should be like windows file open save.
View 2 Replies View RelatedNetworking And Gateways :: Authentication For Connected User Database Links
Jun 15, 2013I know how to use database links in various forms, but I've been trying to think through how the authentication works for a connected user link in 11g. If I create the link like this,
create public database link using 'orcl';
then any user can use the link, provided they have an identical username/password in the two databases. With pre-11g passwords, it was understandable: the password was salted with the username, so the hash of the password would be the same in both databases, and I assumed that the logon through the link used some sort of IDENTIFIED BY VALUES mechanism. But in 11g, the salt will different in the two databases. So the hash will be different. And of course Oracle never stores the actual password. So I don't see how the authentication works.
Server Utilities :: Import Program Without Connecting With Database User
Sep 19, 2011I want to know if it is possible, to run IMP program without connecting with database user , for example :
imp '/ as sysdba' file=f.dmp fromuer=u1 touser=u2 log=flog.log
that permits to perform scripts without passwords in.
Server Administration :: Unable To Drop User Without Database Shutdown
Apr 19, 2013We are unable to drop user due to below error, how to drop the below user without shutdown the database.
SQL> drop user mvm_2010 cascade;
drop user mvm_2010 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
No session was available for particular user.