Forms :: Table Oriented User Rights

Nov 10, 2009

I have build a sw containing 20 forms & 35 reports. I have created users table.

Now I want to assign different rights to different users like update, view , update, print, delete etc etc. Enable disable add/delete/update buttons on basis of user rights.

View 11 Replies


ADVERTISEMENT

Forms :: Login User From One CANVAS And Access Second As Per-user Rights?

Oct 20, 2012

- we have user id parameter.can we update the parameter(:parameter.p_userid) before firing "WHEN NEW FORM INSTANCE TRIGGER"(when new form instance trigger contain code for tree node), for login another canvas as per user rights?

- i have created a login form in one canvas.

- also tree node Hierarchy form created on another canvas. now we want to login through login screen, after login only those forms should show in tree Hierarchy which users have rights. for this purpose we want to pass the parameter of userid before connecting to tree node form through the following query

SELECT COUNT (*)
INTO v_count
FROM usersinfo
WHERE usersname = :USERBLOCK.usernames AND passwords = :USERBLOCK.passwords ;

[code]...

Every thing is working but when we click on button in login form at that time parameter.p_userid will return null. because above code is define on button click in login screen, i cannot understand where i need to define the above code .

View 1 Replies View Related

Show Rights Of A User On Tablespace

May 13, 2013

just a short generally Oracle question with (i think) many solutions:

How is it possible to show the rights of a user on a tablespace?

View 13 Replies View Related

Forms :: How Screen Can Be Center Oriented

Jul 1, 2010

how the forms webpage/forms screen can be center oriented which is by default top left oriented in the content webpage.

View 1 Replies View Related

Forms :: When User Change / Delete Any Record / Row In Forms Data Automatically Move To Other Table

Dec 25, 2011

when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.

View 8 Replies View Related

What Object Oriented Extensions Are Supported By Oracle

Jan 13, 2007

"What object oriented extensions are supported by oracle?"

View 1 Replies View Related

Spatial :: How To Get All The Values Of The SDO_ORDINATE_ARRAY Of A Oriented Point

Dec 14, 2012

I'm trying to get the values of a Geometry which is an Oriented Point. To that, i'm using SDO_UTIL.GETVERTICES, but this utility only obtains the point X,Y, it doesn't obtain the values of the orientation vector.

The Geometry is this:
MDSYS.SDO_GEOMETRY(
2001,8307,NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,1,1,3,1,0),
MDSYS.SDO_ORDINATE_ARRAY(-75.586088632813272,6.1794352615514194,0.57278169530235967,-0.81970795380217887,0)
)

The query is this:
SELECT c.ipid, c.nombre, t.X, t.Y, t.Z, t.W
FROM Hidrantes c,
TABLE(SDO_UTIL.GETVERTICES(c.geometria)) t
where c.ipid = 4691117
ORDER BY c.ipid, t.id;

Result:
4691117          -75,5860886328133     6,17943526155142          (null) (null)

As you can see, it only obtains the X,Y values but not the values of the orientation vector, how can I get the values?

View 2 Replies View Related

SQL & PL/SQL :: How To Extract The Rights Of Users On ERP

Mar 2, 2013

I would like to extract the user rights from the ERP that I use with SQL/Oracle.

There are 3 databases. The first gives me all the users with the main key id_user. The second one gives me the actions with the main key id_action. The third one only gives me what the user can't do.

I would like to know all the actions that all users can do or not.

The result must be something like:

Action 1
User 1 Yes
User 2 No

Action 2
User 1 No
User 2 Yes
....

View 9 Replies View Related

SQL & PL/SQL :: Access Rights To Be Given For Using Pivot Function

Dec 28, 2011

Is any access rights to be given for using pivot function...i tried below query but it throws error

select * from BI_BALNCE_SHEET
PIVOT(sum(balance) for gl in('Income','Expenditure'));

View 8 Replies View Related

Forms :: Backup Of User Table

Jul 20, 2011

Im using oracle forms 10g. i want to take backup of user's table.

i.e, scott user has 4 tables. if i login as scott user and select the tables what i have to take backup using check box and click a backup button,the selected tables backup and stored in .MDB(MS Access).

How to achive this?

View 4 Replies View Related

Update Statement Which Updates User IDs In One Table With User IDs In Another Table?

Jun 17, 2009

I am trying to write an update statement which updates the User IDs in one table with the User IDs in another table. However I need to update statement to ignore any duplicates that are in the tables.

View 4 Replies View Related

Forms :: User Clicks On Declaration_no From Header Table / Other Records Will Be Displayed

Jun 26, 2013

I need to populate records from a child table when the user clicks on a record in the header table..The difficulty is that the user needs to be able to edit a field from the child table and there could be 1 to many records. When the user makes a change , I don't want the 'do you want to save changes' error to appear..

the user will only be able to update field 'amt'.When the user clicks on 'declaration_no' from the header table,other records will be displayed. URL.....

View 5 Replies View Related

Forms :: User Privileges - Assign Permissions To One User To Add / Delete / Edit Data?

May 28, 2011

how can i assign permissions to one user to add,delete,edit data and other user should be able to perform all functions or selected functions

View 12 Replies View Related

PL/SQL :: Join Between Table With User Based Content And Base Table

Jul 30, 2012

I stumbled about some weird 11gR2 behavior (running on AIX).When I performed a join between a table with user based content (parts belonging to an sourcing scope) and a base table (parts available) whereas the parts have to fulfill a special regular expression, it showed that the same query is faster when using outer join than inner join (about 0.7sec vs. 20sec; which makes me believe that regexp_like works wrong when involved in an inner join).

i tried the same statement with a standard like (but not fulfilling the same condition).This time performance was as expected (inner join outperforming outer join).

Oracle version information
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE     11.2.0.2.0     Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
[code]...

I can see it, the execution plan for the "inner join" doesn't show so much more costs than the one for the outer (but why at all is does an inner join cost more?) ...The execution plan for both "not like" is the same and (surprisingly ;-) ) similar to "outer-regexp".

I hope sample data are not needed as there would be needed a lot...this is the second time I came across the "plan worse but execution time better" phenomenon.

View 10 Replies View Related

SQL & PL/SQL :: Grant A User To See All Table Into Another Table

Sep 6, 2011

i need to grant a user to see all table into another table and not to use this option (grant any table)

View 9 Replies View Related

SQL & PL/SQL :: Values Using USER TABLE?

Apr 19, 2011

I am using pay user tables to store the balance values.

Example:

IF rec.balance_name = 'Gross Earnings'
THEN
l_gross := bal_function(g_assg_id,rec.balance_name,'_ASG_GRE_YTD',p_effct_date);
END IF;

from the above I should not hardcode ('Gross Earnings ) value, so I placed this value in pay user table that can be changed by different clients. how do i refer user table values for the right earnings/net/overtime pay values that can be placed in user table.

View 6 Replies View Related

SQL & PL/SQL :: Grant Table Permissions To Another User

Jul 11, 2012

I have two user a and b. I have to Grant select update insert Delete Permission to all tables of user b To User a. how can it possible?

View 5 Replies View Related

SQL & PL/SQL :: How To Insert All User Names Into A Table

Jan 1, 2012

How to Insert all user names into a table from sql for example when i use select * from all_users command it displays all user names i want that how we transfer these user names into a table.

View 11 Replies View Related

How To Grant Truncate Any Table To A User

Jan 30, 2013

on 11G R2,

We want to grant truncate any table to a user.

How ?

We should create the following procedure ?

1. Create the procedure to truncate the table.

create or replace procedure truncate_table (
table_name varchar2,
storage_type varchar2)

[Code]....

grant execute on <procedure_name> to <user>Is it for only one table ? If yes how to do that for all tables ? Or the tables of a schema ?

View 6 Replies View Related

SQL & PL/SQL :: Grants On Nested Table To Other User

Jul 16, 2011

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

[Code]...

View 2 Replies View Related

Forms :: How To Get Web-user In 11g

Jul 4, 2010

I m using Oracle Fussion Middleware Forms 11g I want to get WEBUSER,see below built

SELECT sys_context('USERENV', 'OS_USER') FROM dual;
<< sys_context('USERENV', 'OS_USER')>>

through this builtin I get only Application Server User Name.

View 4 Replies View Related

Forms :: How To Get All User Name In 6i

Jan 1, 2012

How to get all user name in forms 6i like when we connect database and apply following command

select * from all_users

This Command returns all users name i want that this user list appears in forms datablock.

View 1 Replies View Related

Table Has 2 Records With User ID - No Data Found

Mar 11, 2011

i got a prob in executing a query in my oracle.TRANSACTIONLIST is the table and my query is..

select * from TRANSACTIONLIST where USER_ID = '07751A1247'the table has 2 records with that user id.

But it is given result as "no data found".

View 4 Replies View Related

Integrate Same As User Want Output As Table Type

Dec 27, 2012

I've created a type as

CODETYPE TEST_DWH_PROD AS OBJECT
            (WO_RELEASE_DATE DATE,
            SITE_CODE__MFG CHAR(5),
            SITE_CODE__PARENT CHAR(5),
            ORDER_TYPE CHAR(3),
            MFG_TYPE VARCHAR2(10),
[code]....            

the above query is giving the value of current QTD(on the basis of V_REPORT_DATE)..I need to integrate the same as user want the output as table type and he can also give some filter conditions.

View 1 Replies View Related

How To Use User Defined Type While Creating New Table

Oct 13, 2009

That is I have created the User Defined Data Type as following. CREATE OR REPLACE TYPE Bit_Type AS OBJECT(Bit NUMBER(1,0));

After completing this creation of new UDT, I am trying to create the table with this UDT as follows, CREATE OR REPLACE TABLE Sample_Bit ( RegID Bit_Type);

I received an Error Message like:
SQL Error: ORA-22913: must specify table name for nested table column or attribute
22913. 00000 - "must specify table name for nested table column or attribute"
*Cause: The storage clause is not specified for a nested table column or attribute.
*Action: Specify the nested table storage clause for the nested table column or attribute.

View 1 Replies View Related

SQL & PL/SQL :: How To Identify Which User Has Changed Table Structure

Jun 21, 2012

a table structure is modified every now and then because of which the few packages get uncompiled. is there any way to monitor which user has changed table structure.

View 2 Replies View Related

SQL & PL/SQL :: How To Check If User Has (create Table) Privilege

Jun 29, 2011

1.How to check a user has 'create table' privilege?

2.how to check a user has privilege to grant 'create table' privilege to other user ?

View 6 Replies View Related

Select Privs On Table To Existing User

Mar 18, 2013

I have granted select privs on below tables to an exisiting user.grant select on WEB.ALMSTAT to nms...I would like to view the privs that i have granted to nms user?

*"In production, nms user will need the ability to read the following tables:*

*WEB.ALMSTAT*
*NET.ASSET*
*NET.LOCATIONNAME"*

View 2 Replies View Related

Creating A User Through Forms 6i?

Sep 12, 2010

I created a form that would allow a user to create another user.i tried creating a user in forms 6i using the following code on the when button pressed:

BEGIN
forms_ddl('create user'||:user_name||'identified by'||:pasword);
commit_form;
END;

pasword and user_name are captured in the form.

View 2 Replies View Related

Forms :: How To Get Details Of USER

May 26, 2010

I want to save ip address, os username, terminal information at the time of record insertion/updation therefore I am using sys_context function but it gives me error at the time of form compilation.

ERROR:

ORA-00600: internal error code, arguments: [17069],[134386616],[],[],[],[],[],[]

My user has already DBA privilege.

View 12 Replies View Related







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