Security :: Possible To Get List Of Tables On Which Audits Enabled
Apr 19, 2013Is it possible to get a list of tables in a schema on which Audits are enabled.
View 2 Replies
ADVERTISEMENT
Security :: Enabling Audits Can They Be Applied On Tables Or Whole Schema
Apr 19, 2013Enabling of auditing in oracle database, can this be done on some tables or applied on the whole schema/user.
View 5 Replies View RelatedSQL & PL/SQL :: Conducting Security Audits Of Database - Three Privileges
Oct 24, 2013While conducting security audits of our databases, I noticed that the DBA role has three privileges I've never heard of, let alone used:
UNDER ANY TABLE
UNDER ANY TYPE
UNDER ANY VIEW
I can't find anything in the Oracle documentation or on Metalink about them.
Security :: How To Check Audit Enabled For Particular Schema
Jan 11, 2012 how to check that audit is enabled for any particular schema.
The below is my audit parameter from database level:-
SQL>SHOW PARAMETER AUDIT
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /db17/dbdump/xxxx/adump
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB_EXTENDED
Forms :: Disabled List Item Will Be Enabled Accordingly Just By Clicking
Feb 4, 2013I have a problem in oracle forms. I have a block that displays five records in list item. On load, it will query two data in my table. So the list item (poplist) one and two enabled. (The default of oracle forms - List item one and two are enabled and the rest are disabled because one and two have data).
My problem was, what work around will I gonna do so that if I pressed the mouse in the third list item it will automatically enabled (for a new record) and if I pressed the list item one or two the third item will stay disable (even the fourth and fifth) because simply the user wants to update the item one or two in the list.
SQL & PL/SQL :: PCT Is Not Enabled While Creating Mview / Though Base Tables Are Partitioned
Apr 4, 2011I created a mv for one of the partitioned tables but on viewing the mv capabilities it still shows PCT is set to 'N'.
create materialized view MV_summary_SEC
refresh fast
start with sysdate
nEXT SYSDATE + 1/24
enable query rewrite as
[code]....
If i remove the sub query and create the mview like this,then PCT is enabled.
create materialized view MV_summary_SEC
refresh fast
start with sysdate
nEXT SYSDATE + 1/24
enable query rewrite as
select PERIOD , SUM(SUM_WEB_HITS)
from summary ,date_table
where PERIOD >= DATE_TABLE.CUR_DATE
group by PERIOD
Is it simply because oracle doesn't support PCT if the definition contains subqueries ?
Workspace Manager :: Export Data From One Server To Another / Version Enabled Tables?
Jan 30, 2013I'm currently having a problem with regards to Exporting data to another server. This is the Scenario:Source Server is Production Server with all of its Tables in the Schema are Version-Enabled.
Destination Server is a Test Server.I exported data from Production Server using EXP command. Then in my Test Server I imported my data using IMP command (I already created tablespace and user for the Schema).Import is successful in my Test server but when I execute my queries, There are no rows returned.
I checked my _LT tables and it contains my data. but when I query from the View created when version was enabled, no result is returned.Am I missing something when I exported and imported my Schema? Should I have included the WMSYS schema when I created the .dump file?
SQL & PL/SQL :: List All Tables Connected To Each Other With Constraints And List All Together
Apr 22, 2013I just want to list and group all my tables that are linked together by constraints. I just want my tables to be able to be listed together as one particular database. my tables are , CUSTOMER, ORDER_INFO, ORDER_LINE, PRODUCT. They're all linked together by way of constraint and I want to list and print them all together as one DB. HOW DO I put them all in one schema and then also list them all together and print/illustrate them as one. also, I tried to import them into their own scheme but i ran into a series of probs regaurding the .dmp file being read.
View 2 Replies View RelatedSecurity :: List Of All Bugs Fixed In A CPU
Aug 13, 2013Is there any page where I can find a list (with descriptions) of all the bugs fixed in a particular CPU (such as July 2013, #16742095)? The readme for the patchset has "Bugs Fixed by This Patch" in section 6, but that is just some patch numbers, with no description. In oracle support, searching by bug id for any of those numbers, returns a "bug not found" page. I would like to have a formatted table with the bug numbers and a link to a detailed description for each bug.
Even the links on the patch details page go to "page not found".
Security :: Find A List Of Roles And Privileges In Database?
Feb 24, 2011How can I list all the roles and privileges of roles in Oracle? Can I get the details of the activities they perform?
View 12 Replies View RelatedSQL & PL/SQL :: How To List All Tables Containing Column Name
Aug 4, 2011How do i list all tables from dba_tab_columns which contains both column name='id' and 'date'. I don't want to list the tables contains either 'id' or 'date'
View 8 Replies View RelatedGetting List Of Populate Tables In A Database?
Feb 9, 2012The database system they have has around 5000 tables. The majority of these are not used (it is an off the shelf package). What I am trying to do is get a list of all tables in the database BUT only those that contain records (not the empty tables) and then copy this to an excel spreadsheet. We use a tool called aquadata to run sql enquiry statements on.
View 5 Replies View RelatedSQL & PL/SQL :: How To Get Distinct List Of Clients From 2 Tables
Nov 8, 2010I have 2 tables which contain 1000's of cash and stock transactions and I need to somehow get a list of the distinct clients
select distinct client_id
from pf_cash_txns pct, pf_stock_txns pst
Quote:ORA-00918: column ambiguously defined
SQL & PL/SQL :: Retrieve List Of Tables With Same Name From Two Schemas
Sep 16, 2013I need to retrieve the list of tables with same name from 2 different schemas.
View 10 Replies View RelatedSQL & PL/SQL :: List Records Being Deleted From All The Tables
Jan 10, 2011I am executing a script that is deleting some parent records and the corresponding child records as I have used the "on delete cascade" with the Foreign key Constraint.
My question is that can I list the records that are being delete from all the tables i.e. both parent and child tables. Is some thing like spooling can work in this or do I have some other option with which I can see(select) all the deleted records.
PL/SQL :: List Of Unused Tables And Procedures
Aug 28, 2012I am in the task of clean up of tables. I need to find the list unused tables and procedures. Is there any way where i can find when was the last time the table queried?
Give sql query to find the list of unused tables and procedures.
PL/SQL :: How To Join Tables And Get Ppl Not In The List From Other Table
Nov 2, 2013I have 2 tables Table a(girlscoutid, item, quarter)Table b(girlscoutid, fname, lname) I want to get the names of ppl who did not sell any item/s for the
4th quarter
girlscoutid item quarter7771
drinks 4QS9000
tickets 4QW7771
cookies 2QS5085books 3QF3010tickets3QW5085
cookies1QF lscoutid
fnamelname7771 jenn richochet9000 laura wilkins5085sally mae3010dora mckenzie
This is what I have, however, I get duplicates and also 7771 shows up on the list even though she sold an item on the 4Q.
SELECT fname, lname, a.girlscoutid
FROM a,b
WHERE a.girlscoutid = b.girlscoutidAND term NOT LIKE '4Q_';
Security :: Oracle Internet Directory Tables
May 5, 2011Does any technical details on the tables found in Oracle Internet Directory? I've checked eTRM and google etc.. - nothing there apart from very minor snippets. I'd like logical schema drawings (PDF) if possible or even a list of the tables and what they do as like the modules in EBS.
View 3 Replies View RelatedSecurity :: Prevent Users From Updating Tables
Sep 9, 2010i've created a schema, which contains 30 tables. the tables are accessed & updated through a web based application. i've made public synonym for all tables for some reasons. how can prevent any one other than application users from updating the tables from Sqlplus.
View 2 Replies View RelatedClient Tools :: List Of Tables In PL/SQL Developer
Feb 4, 2010I can do any sql commands against the schema I want (PSUSYS) with my username(SCHWAN) in the sql window, but when I want to export a table(created with a different schema) no tables are listed in the export window. This does work for my coworkers with the same access.
At one time this used to work so I'm wondering if it is a parameter that I inadvertently changed.
SQL & PL/SQL :: Query That Will Give List Of Views Using Three Tables?
Aug 16, 2011I wanted a query that will give me the list of views using three tables
when i fire
select * from dba_views where text like '%SELECT%';
it is giving me error as expected number got long.
PL/SQL :: Variable To Pass A List Of Names Between 2 Tables
Jun 4, 2013I am trying to pass a list of names from one table as a variable to another table and trying to find the Highest level they exist at in the hierarchy. I am having some troubles with the variable and need some guidence and also if this should be a procedure or not.
this is what i have now :
Variable man_name Varchar;
exec :man_name = (Select full_name from direct_manager_report)
UPDATE direct_manager_report
Set Manager_level_number =
[Code]....
Let me know what modifications have to be done for this the variable to get the name from table 1 and find the manager level from table 2 and populate it back in table 1.
Security :: Restricting DBA Access To All Data Of The Tables (Encryption / Others)
Nov 4, 2012We have got a new requirement wherein, The customer wanted the DBA Vendor (US) NOT to access the confidential information (ALL Columns) in the DB tables of PRODUCTION database. This is for few applications to comply with with export control rules. The thin support by Customer DBA will be allowed to access the Data, if required .
1) Web Based Interface ?.
2) DB Encryption (But if we encrypt ALL columns Serious performance issue expected, File level will not restrict DB level access)
3) Special setting on DB (DBA to do only backup and restoration related work only - But cannot access data)
4) Standard Tools / Utilities / Others ??.
Technologies are Oracle ,SQL
Find List Of Tables Inserted / Updated In Last 6 Month
Oct 7, 2012I tried to find out recently updated table list. I couldn't find anything.
CODE>> JUST SAMPLE TRANSACTIONS >>
SQL> conn sam
Enter password:
Connected.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BIN$y1TXhcjGApvgQAB/AQBOpA==$0 TABLE
TAB1 TABLE
[code]........
SQL & PL/SQL :: Query To Find List Of Tables Contains Particular Data In Schema?
Feb 3, 2012I want to list the tables in a schema which contains a particular value or data.
View 2 Replies View RelatedSQL & PL/SQL :: List All Tables In Database With Particular Record Values Combination
Jul 1, 2013I have 3 tables in the Oracle database( emp, employee, emp1) which has following record values in it.
empidenamejob
7369, 'SMITH', 'CLERK'
I would like to list these 3 tables thru SQL/PLSQL, having the above record values combination. Also, the name of the columns could be different in all the tables i.e. name could be 'ename' in Emp table , and 'name' in Employee table. Is there way to do this in SQL or PLSQL ?
ILM Assistant :: Unable To Get List Of All The Tables Of Oracle EBS R12 Database?
May 13, 2013I am trying to attach lifecycle definitions to tables of Oracle EBS R12 database, using the "Refresh table list" option of ILM assitant.
Though its showing the refresh job running to completion, but its not displaying the list all of tables.
Tried it with narrowing the search for a single schema but no luck.
how to get the list of all tables or at least list of tables belonging to a schema in Oracle EBS R12.
Enterprise Manager :: List Of Tablespaces And What Tables And Indexes Are In Those Tablsespaces?
Oct 21, 2011Whats the easiest way I can see a list of tablespaces and what tables and indexes are in those tablsespaces? Can this be done through OEM?
View 3 Replies View RelatedXML DB :: How To Secure Files Stored Where TDE Enabled
Nov 29, 2012I want to secure files that I saved in xml db with TDE, but tablespace encryption(tde) is not supported on the sysaux tablespace.
Is there any way to move the tables where XML DB saves data to another tablespace where TDE is enabled?
XE :: ORA-00439 / Feature Not Enabled / Partitioning In 10g
Dec 3, 2012ORA-00439: feature not enabled: Partitioning...
how to enable partitioning in database....
my version is......
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production.
