As per my req, i need to get the system grants of one user (GRANTEE) using DBMS_OUTPUT API. The requirement get completed using 'SYSTEM_GRANT' as parameter for OPEN function in the metadata api. Please look into part of code which works.
The second set filter doesn't work to get SYS GRANTS of one user. It does not throw any error. Simply the filter doesn't work. 'GRANTEE_EXPR' is not a correct value in the 2nd set filter. What parameter need to pass in object_path_expr ('GRANTEE_EXPR')?
We have base tables in "sdt" , Views are created in "sdm" schema based on the "sdt" schema tables We have granted privileges on the base tables of "sdt" schema to "sdm" schema.
Sometimes views are not able to access by sdm schema.Again we are granted privileges on the base tables of "sdt" schemathen views are able to access.How grants are revoking automatically.
I have an issue on selecting data from a nested table owned by other user.
I have given select access on stc_irb_usr.stc_loy_settlebillpay_map_main to anthr user adminofs.
But when I try to query, it says insufficient privileges. adminofs is able to select other columns which are not nested.
I have given "grant execute on STC_IRB_USR.STC_BILLPAY_MAP_TAB_TYPE to adminofs;" but it did not
select * from stc_irb_usr.stc_loy_settlebillpay_map_main where rownum<3;
ERROR: OCI-21700: object does not exist or is marked for delete
SQL> desc stc_irb_usr.stc_loy_settlebillpay_map_main Name Null? Type ----------------------------------------- -------- ---------------------------- BATCH_NUM NOT NULL NUMBER ACCOUNT_NUM NOT NULL VARCHAR2(40) PAY_BILL_SEQ_MAP STC_IRB_USR.STC_BILLPAY_MAP_
[Code]....
Name Null? Type ----------------------------------------- -------- ---------------------------- ALLOCATING_CREDIT_SEQ NUMBER ALLOCATION_ENTITY_SEQ NUMBER ALLOCATING_CREDIT_DATE DATE ALLOCATING_CREDIT_TYPE VARCHAR2(20) ALLOCATION_ENTITY_DATE DATE
Those grants were generated automatically by oracle. Is there any way to prevent Oracle to grant them? An external audit-rule tells us not to give any grant directly to user - we always have to use databaseroles.
I did an export using the following parfile (see below) I want to import all the objects associated with this schema into another DB but I want don't want to over-write any of the permissions such as grants.
Is there a way I can get the grants into a sql file before I do the import. If so, provide an example.
couple of questions about below parameters, do they measure single processor or avg usage across all processorss and cpus for example will i recieve alert if CPU system time goes above 95% for single processors? or not
CPU Idle Time (%) CPU System Time (%) CPU User Time (%)
regarding grants given on object doesn't reflect on Oracle forms 6i.When my developer compiled the form the error throws object was not declared which means oracle form not able to access the object which is synonym of other table.Also we recreated the synonym and given grants from table owner and compiled form still throws same error,But i can able to select object from backend command but not from oracle forms.
grants reflect in oracle forms after we restart the database.
Every time i try to refresh my production DB with the a old expdp dumpfile using data pump i always face the issue of grants and creation of synonym. I would like to tell you that my DB has three schemas which have lots of dependencies among them and before refreshing them i drop the schemas and recreate the same.
Drop user user_name cascade;So i want to know, is there a script from which i can get all the grants of the DB before dropping the schemas, so that after import i can grant the same and also a query with which i will be able to get all the synonyms of the DB.
I am not sure if Oracle has a simple solution for a problem that I have in retrieving data?
Conditions:
As per rule we have to hold data from 7 - 10 years so the data can be searched at any given time.Don't want to purge data and keep the historic data separate so the request can be redirected based on the year.
I am looking for a solution similar to windows .ocx search. When a application is requesting an ocx (active X control) the search happens in C;\windows\system32 and if the ocx doesn't exists then the search is done on the entire system. Similarly can a table be partitioned (just the term I am using not discussing Oracle partition here) so I can partition data from 2011,2012 and 2013 to search first and if the searched data doesn't exists then search the other partition (data from 2003-2010) ?
I have one column name party_name containing Korean Characters and English characters.Some of the English characters have different symbols.My requirement is to get the data and exclude those symbols but not Korean characters.
Already I used a function to replace special symbols with space.The function contains code based on ASCII values it works good but it filters Korean characters too.the attachment of the screenshot, When I double click the name it shows with some question mark.
I'm having difficulty trying to show a list of forms that I would like to present the user after they log on with SSO.
The funny thing is that I can show the user in a message box. However, I cannot filter records that the user should have on an "Application" menu. The application menu is designed to allow the user to launch the form by double clicking on the menu item. That works fine. It is just that I cannot seem to filter. It shows no records.
Here is my WNFI
DECLARE sso_user varchar2(40); nn number; v_vis VARCHAR2(20);
I get no rows - why? Obviously the predicate 1=2. Except, equally obviously, I don't have that in the query. On checking the objects views I see that ccs.payment method is indeed a table within that schema not a view or anything like that and when checking through another user I can see it has data within.
The "problem" user can see the table exists, just cant ever query rows back. Another user can see the table exists and can get data back.
Like I say, likely a priv or similar issue but I'm damned if I've seen this before, I'd not expect a priv issue to cause a 1=2 filter appear in a plan and its not a view that I can tell.
I'm still digging at my end and this may be irrelevant but when I browse to the table in Sql Developer I can see the columns tab ok, on clicking the "data" tab it throws "ORA-00904: "ORA_ROWSCN": invalid identifier" out. Maybe nothing, maybe related.
Google results suggest that error in SQL Dev is due to implementations of policies/VPD presence on the table.
Sample DateWITH DATA AS ( SELECT 'AAAXXXX IO BLUEEXPRESS' LIST FROM dual UNION ALL SELECT 'BLUEEXPRESS AAAXXXX IO BLUEEXPRESS' FROM dual UNION ALL SELECT 'DDDDD BLUEEXPRESS AAAXXXX' FROM dual UNION ALL SELECT 'DDDDD DDDDD AAAXXXX' FROM dual UNION ALL SELECT 'DDDDD BLUEEXPRESS AAAXXXX NO CARBON' FROM dual UNION ALL SELECT 'NO CARBON [code]....
The above result depends on the following rules:
- Replace BLUEEXPRESS into BEXPRESS - Remove the term NO CARBON (See row no 6) - Reduce all multiple space into single space (see last record).
So far I create separated queries for replacing BLUEEXPRESS into BEXPRESS and replace NOCARBON term but I don't know how to do it in a single shot as well as stuck on scenario to remove multiple spaces and put single space.
I have a block in the form which is based of a table as data source and so when i query on the form using a execute_query inbuilt statement is fired and all the records in the table behind is retrived and displayed. Also if i need to update any record i can do in on the screen and use commit_form so that all the changes go into the underlying table. Now my problem is when i retrieving my records i want to filter those records based on some conditions to be displayed in the form and not all records to be retrieved. Is it possible to do it if I am using the execute_query inbuilt and my block is based of a table?
I need to filter ticket prices according to the class; i.e.
CASE WHEN booking_class = 'Economy' THEN economy_saver ELSE 0 END AS ECONOMY_SAVER THEN economy_basic ELSE 0 END AS ECONOMY_BASIC THEN economy_basic_plus ELSE 0 END AS ECONOMY_BASIC_PLUSEND, CASE WHEN booking_class = 'Business' THEN business ELSE 0 END AS BUSINESS THEN business_flexible ELSE 0 END AS BUSINESS_FLEXIBLEEND.
..The objective is to show only the prices that belong to the selected class. I am not sure if my sql is correct at this point.
Want to filter a data using CASE statement in WHERE clause for the following scenario.
Need to Filter tb1.fallback_keyword if the fallback_flag is "Y' or 'N' and pg_number is null.Else no partial search of keyword.
where CASE WHEN (fallback_flg = 'Y' OR fallback_flg = 'N') and (pg_number is NULL ) THEN tb1.fallback_keyword = SUBSTR(key_word,1, INSTR(key_word,'#',-2)) ELSE (tb1.keyword = key_word ) AND (tb1.keyword like regexp_replace(key_word, '[*]+', '%')) END
Is it possible to filter each row in a select statement based upon a list that you loop through. For instance in a where clause having an in statement but rather than selecting any value in the in statement looping the main select through each value in the "in" filter.
Eg:
CREATE TABLE TRANSAC( Item_id number , Transaction_Date DATE, Category_id number )
You could then write
SELECT MAX(Transaction_Date) from TRANSAC where category_id = '141'
and then where category_id = '142' then '143' etc.
I understand i could use an inline view instead of a where clause but the issue is that i already have the list of values I want to compare against.
I am using Apex 4.1 and builder theme.I came across this thread to filter the shuttle values based on javascript in dynamic action.Auto filter Shuttle selection list
I created a shuttle and a textbox as described but the dynamic action is not clear. And It is not working for me. The steps are not so clear and i guess the javascript is not complete.
I need to filter a SQL statement with an application item value retrieved from session state. I am assuming I could do this using a Dynamic Action on a Page Load event but I'm not sure where to go from here. How could I append the filter to an existing report page SQL statement?
