SQL & PL/SQL :: Created 2 Users Named User_a And User_b In Database

Mar 2, 2012

I have created 2 users named "user_a" and "user_b" in my database and i gave "connect","dba" and "resource" roles to both users,then i created a table,synonym in user_a and i observe that user_b can also access this table and synonym of user_a without "granting" to "user_b", how it is possible. is it because of any of above role?

View 12 Replies


ADVERTISEMENT

Server Administration :: How Many Users Can Be Created In Oracle 11g Release 2 Database

Dec 27, 2012

how many users we can create in oracle 11g release 2 database. Is there any specific limit or parameter for that.

View 1 Replies View Related

SQL & PL/SQL :: Select All Users Created By Oracle?

May 4, 2012

During installation of a database Oracle creates several users. Also when using DBCA in a later stage to add more options Oracle can create more users.

Here's my problem: Public synonyms never get exported using exp(dp)/imp(dp) utility. Ofcourse using public synonyms isn't good practise, but sometimes handy. Unfortunately in our environment they have been used a lot in the passed.

So I want to create an SQL statement that does the trick and returns only all users that were NOT created by Oracle software.

I've tried several things, but can't seem to distinguish Oracle users from Manually created users.

View 7 Replies View Related

Backup & Recovery :: Replace All Folders Of Same Named Database - Getting Error?

Mar 23, 2012

i have an issue while in backup and recovery. first of all i want to explain what i did, at first i create a database and named "testdatabase" on my machine then i create a new user say "newuser" and gave some roles and i created tablespaces and some tables in it and after that i stopped the service of "testdatabase",then i copied the folder of "testdatabase" from admin, oradata,flash_recovery_area and rdbms from diag folders at another location on my system.

then i login to "testdatabase" through sys after starting the service,then i drop "newuser" and stop the service again then i replace the folders of "testdatabase" from coressponding copied folders(from its original files) then i start the service and login to "testdatabase" through the "newuser" then all data is recovered successfully.

but when i tried to replace these all folders to the folders of the same named database which is on another machine (i have copied it by stopping the service of it)after stopping the service and then i tried to connect it then it throughs an error-"ORA-01033:

ORACLE initialization or shutdown in progress" and i wait for 3-4 hours for it , but same error.

View 7 Replies View Related

Server Administration :: Find When Database Role Created And Who Has Created?

Feb 14, 2013

Is there a way to find when was a database role created and who has created?

View 5 Replies View Related

Create As Many As 100 Database With Upto 100 Users (max) For Each Database As Client

Aug 25, 2010

I have CPU based Oracle server license. In this case as per license policies of Oracle I can have unlimited database with unlimited users connecting it.

I need to create as many as 100 database with upto 100 users (max) for each database as client. What is the recommended hardware for this server? CPU/ RAM/Harddisk, recommended chipset on the motherboard (in case of database storage capacity required is not high typically - 20 GB is OK per database - average), redundancy is critical, also Oracle database vault is going to be installed; as security is of prime importance between users of different database. Which specific server models from specific vendors like IBM/ Dell/ HP are good ones for this purpose?

View 2 Replies View Related

SQL & PL/SQL :: Create A Row-level Trigger Named TRG_PROB_FEE?

Dec 3, 2010

I'm trying to create a row-level trigger named TRG_PROB_FEE to run before insert or update of the problem fee attribute on the problem table. If the associated DML command would result in a null for the problem fee(prob_fee), then get the value of the problem fee attribute from the associated contract (con_probfee) to use as the value for problem fee (prob_fee) in the Problem table.

CREATE OR REPLACE TRIGGER TRG_PROB_FEE
BEFORE INSERT OR UPDATE OF PROB_FEE ON PROBLEM
FOR EACH ROW
BEGIN
IF :NEW.PROB_FEE IS NULL THEN
SELECT CON_PROBFEE
INTO PROBLEM
FROM CONTRACT
WHERE CON_PROBFEE = :NEW.PROB_FEE
END IF;
END;
/

View 8 Replies View Related

PL/SQL :: Couldn't Access Dba_segments Table From Named Stored Procedure

Feb 7, 2013

we couldnt access the dba_segments table from the named stored proc however its working fine if accessing from unnamed SP.

SQL> declare
  2  cnt number;
  3  begin
  4  select count(*) into cnt from dba_segments;
  5  dbms_output.put_line('cnt='||cnt);
  6  end;
  7  /
cnt=6746

PL/SQL procedure successfully completed.SQL> create or replace procedure test

  2  is
  3  cnt number;
  4  begin
  5  select count(*) into cnt from dba_segments;
  6  dbms_output.put_line('cnt='||cnt);
  7  end;
  8  /

Warning: Procedure created with compilation errors.

SQL> show error
Errors for PROCEDURE TEST:

LINE/COL ERROR
-------- -----------------------------------------------------------------
5/1      PL/SQL: SQL Statement ignored
5/31     PL/SQL: ORA-00942: table or view does not exist
SQL>oracle version
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production

View 4 Replies View Related

REFRESH GROUP Is Automatically Created When A Materialized View Is Created?

Aug 17, 2012

tell me if a REFRESH GROUP is automatically created when a materialized view is created?

View 3 Replies View Related

Application Express :: Add Button On Report Region Named As Send Email

Dec 28, 2012

I want to add button on report region Named as "Send E-mail" that should be on each row

so how can i do?

View 8 Replies View Related

SQL & PL/SQL :: When Database Trigger Created

Jun 28, 2010

if i want to know when (date/time) that the Database Trigger created? I am using Oracle 8i, so is it possible to check when (date/time) ?

View 2 Replies View Related

PL/SQL :: Created Two Jobs In Sys Database

Mar 11, 2013

I have created two jobs in sys database as follows,

BEGIN
sys.dbms_scheduler.create_job(
job_name => 'JOB_FCDB_CHARGES',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN FCDBCHARGES; END;',
repeat_interval => 'FREQ=DAILY;BYHOUR=19',
job_class => 'DEFAULT_JOB_CLASS',
comments => 'Job to process Internet Banking Charges.',
auto_drop => FALSE,
enabled => FALSE);
[code]....

It has been successfully created.Even i get the entry in dba_objects table as follows,

select owner, object_name, object_type from dba_objects where owner = 'SYS' and object_name like '%JOB_FCDB_CHARGES%';

But, my problem is when i log in to PL/SQL developer i am not able to see anything under job.

View 9 Replies View Related

SQL & PL/SQL :: How Many Users Can Connect With Database

Apr 23, 2010

I want to know what will be the performance of my DB before loading data and how many users can connect with my database.

View 7 Replies View Related

SQL & PL/SQL :: Created Table With Date In Database

Feb 22, 2011

Me working on Oracle application Express,there are lots of tables created in it, how will i get to know who created which table and on which date.

View 7 Replies View Related

Created Database Link But Does Not Function

Jun 19, 2012

in a 9.2.0 db I create a db link but does not function :

CREATE DATABASE LINK "ONEDB"
  CONNECT TO "user1" IDENTIFIED BY "****" USING 'ONEDB';

SQL> select * from dual@"ONEDB";
select * from dual@"ONEDB"
                   *
ERROR : ORA-12154: TNS:could not resolve service nameBut on the same server I can connect to 11g in sqlplus :

Z:>sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Mar. Juin 19 10:13:45 2012
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> connect user1@ONEDB
password :
Connected.Of cours the other DB links toward 9.2.0 databases work well.

View 4 Replies View Related

How To Limit Users From Connecting To Database

Aug 14, 2012

i have a database nd only 10 users must allowed to access db at any point of time and sessions per user must be 1.that is only 10 users must be able to access the database.

View 6 Replies View Related

Server Administration :: How To Get Password For Database Users

Nov 24, 2010

get the actual password for the database users. If we talk about the dba_users account we have password in the encrypted form how to decrypt them and get actual password.

View 6 Replies View Related

Application Express :: Adding Users To A Database?

Nov 7, 2013

I have an application that I am adding users to as end users. How do I assign them to a particular application? I am using Apex 4.1, Oracle 11g. 

View 10 Replies View Related

Server Administration :: How To Get Size Of All 80 Users From Database

Mar 19, 2012

select username,account_status,default_tablespace from dba_users;

The ran the above query and it return 80 users but when i ran below query it shows just 14 rows.

select owner,sum(bytes)/(1024*1024) "GB" from dba_segments group by owner;how to get the size of all 80 users from database ?

View 2 Replies View Related

Server Administration :: Connect To Newly Created Database?

Jan 16, 2012

i create new database (Student) using command line, now i want to connect with newly created database (using sys as sysdba), but again it directly connected with old database (ORCL). So what should i do to connect with newly created database (Student).

View 3 Replies View Related

Security :: Fire Trigger If And Database Object Will Created?

Nov 7, 2013

How to write and fire trigger if any database object will created?

View 1 Replies View Related

SQL & PL/SQL :: Created Trigger On Database Level In System Schema

Jun 10, 2010

I have created trigger on database level in system schema. While i am creating new tables in system schema, trigger logged the entry but when i am creating table in scott schema it is not working for that.

CREATE OR REPLACE TRIGGER ddltrigger
AFTER DDL ON DATABASE
BEGIN
INSERT INTO aud_log
(user_name, ddl_date, ddl_type, object_type,
owner, object_name
)
VALUES (ora_login_user, SYSDATE, ora_sysevent, ora_dict_obj_type,
ora_dict_obj_owner, ora_dict_obj_name
);
END;

View 3 Replies View Related

Assign Different Profile For Oracle Database Users According To Their Job Functions

Apr 10, 2011

it is a good practise to assign different profile for oracle database users according to their job functions.what could be the resons for that?

View 3 Replies View Related

Forms :: Create Different Database Users Like STORE / PAYROLL

Apr 12, 2011

I create different database users like STORE, PAYROLL, GL , SYSADMIN, COMMON to contain objects accordingly then I create another user ABC and grant DBA privileges to all users.

After that I grant SELECT/INSERT/UPDATE/DELETE privileges on each and every objects of STORE/PAYROLL/GL/SYSADMIN/COMMON users to ABC then create synonyms of STORE/PAYROLL/GL/SYSADMIN/COMMON users objects into ABC.

Actually, I want to use single user of ABC to build/execute my application but I think I am doing something wrong because whenever I tried to compile my form, its showing this error.

View 8 Replies View Related

SQL & PL/SQL :: To Find Time At Which Query Fired By Any Of Users In Database

Oct 25, 2010

I have 10 users in my database, I need to find the time at which a query is fired by any of the users in the database. provide the query for this? I think i have to use V$sql,v$sqlarea or v$sql.

View 1 Replies View Related

Security :: View / Obtain Password Once Database Link Has Been Created?

Dec 24, 2011

Is there a way to view/obtain the password once a database link has been created. Some sys dba table?

View 7 Replies View Related

Security :: How To Edit Created Policy (Virtual Private Database)

Mar 28, 2012

I Created the Security Policy as user sysadmin_vpd as follows

BEGIN
DBMS_RLS.ADD_POLICY (
object_schema => 'scott',
object_name => 'orders_tab',
policy_name => 'orders_policy',
function_schema => 'sysadmin_vpd',
policy_function => 'get_user_orders',
statement_types => 'select');
END;

After creation this policy I want to view & edit them.By default where they are saved.

View 3 Replies View Related

Backup & Recovery :: RMAN Configuration For Newly Created Database

Oct 1, 2011

i am trying to configure rman for newly created database .when i entered

rman target /

it is throwing following error

[/u01/app/oracle/product]rman target /

Recovery Manager: Release 9.2.0.8.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12162: TNS:service name is incorrectly specified

View 6 Replies View Related

Server Utilities :: How To Import Backup On Newly Created Database Using Imp

Nov 18, 2011

I have near 114 export.dmp.z* export backup. I am trying to import it on newly created database using imp.

But i am not getting how can i select all export.dmp.z* files using imp. Its easy in impdp, but i have exported backup.

View 7 Replies View Related

Automatic Storage Management :: 10.2.0.1 RAC - ASM Created - DBCA Could Not Create Database

Jul 30, 2012

I am using 10.2.0.1 on OEL5. I have installed CRS, Oracle home, ASM on both nodes and everything is fine.

When invoked dbca to create a database, it says:

*'DBCA could not startup the ASM instance configured on this node. To proceed with database creation using ASM you need the ASM instance to be up and running. Do you want to recreate the ASM instance on this node?'*

Is it a bug? because some blogs say this is a bug. And patch 8288940 will solve this. They also say this patch is to solve the incompatibility between 11g ASM incompatibility with 10g. But here I am using everything of 10.2.0.1.

View 4 Replies View Related







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