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.
I am creating a New User by using our customized Oracle Form for Creating a New User.
I am ting the Bellow errors:
-604-ORA-00604 : error occurred at recursive SQL level 1
ORA-200001 : failed to create user,please contact dba for support.
ORA-06512: at line : 16
I am using ORacle Forms 10g as a Front End and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production as Back end.
I have a strange problem when creating a view in user from another user
I have a user called "Cash_tst"
its syntax creation is
-- Create the user
create user CASH_TST
identified by ""
default tablespace CASH
temporary tablespace TEMP
profile DEFAULT
quota unlimited on cash;
-- Grant/Revoke object privileges
grant connect to CASH_TST;
grant dba to CASH_TST;
grant resource to CASH_TST;
-- Grant/Revoke system privileges
grant create any view to CASH_TST;
grant unlimited tablespace to CASH_TST;
I want to create a view
CREATE VIEW TAMER
AS SELECT *
FROM [b]AROFL[/b].RA_CUSTOMER_TRX_LINES_ALL_BEFO
"AROFL" is another user on the same database
when try to create the view "tamer" i got message of
"insufficent privilege"
although i granted "create any view" to the user "cash_tst"
I am trying to create a new user who will be able to do a delete from all of the tables that only I MYSELF created. I created my user and granted access but realized I may not have done it right..
is it simply SQL>grant delete on <TABLESPACE> to <new user>; ? or do i need to specify the grant the delete on my tablespace to new user?
I need to create a user on oracle aix to never expire. I did the following
create user identified by password
grand dba to user
alter user password_life_time unlimited
is this all i need to do?
i want to create a group xyz and add some users to xyz group and want to grant/revoke permissions to xyz. So that all the users present in that group will have the same permissions as of the xyz group. so that instead of giving the permissions to users individually i can give it at a time.
View 20 Replies View RelatedWe are using oracle forms 6i as front end and oracle 10g as back end.When we are creating a new user, the password should be stored in back end table in encrypted format.
View 4 Replies View RelatedThat 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.
i have a field in one table called item_name based on which i am creating new item name as duplicate with new given length, for eg there is one item_code which has length of 12000mm i am going and replacing the string using instr function and replace function based on criteria that where i will find mm it will extract a portion and replace the new length as 6300mm.But its failing because some time user is creating the original item code without mm, is there a way.
Original:'H194x150x6x9x8x12000mm, 29.9 kg/m, ASTM A992M'
New : 'H194x150x6x9x8x6300mm, 29.9 kg/m, ASTM A992M'
comes some times he is entering mm and sometimes he is entering without mm as
Original:'H194x150x6x9x8x12000, 29.9 kg/m, ASTM A992M'
New : 'H194x150x6x9x8x12000, 29.9 kg/m, 6300'
I have been asked to improve the speed of our extract feeds to another team. It was using an excel file as csv created with C# reading the csv into a global temporary table and a procedure to insert rows from global table to main table one at a time.
Around 1 million rows That was taking around 25 min. After trying sqlldr and an intermediate table I managed to reduce timing to 15 sec with sqlldr and Direct Path Load. I tried all that in one of our own DEV databases. Now we want to try the approach in one of DEV databases belong to downstream group (the one we feed data). They are rather reluctant to give me access to their DEV database! I have asked them to create a new login and grant object creation (DDL) to this user.They keep saying that they are prepared to give me a role but NOT schema owner. What is the best way of enabling me to create tables somewhere and test loading times with sqlldr.
I need to do full DDL (table/proc creation) and DML on a certain schema. So my question: What is the best way of doing so.. Do I need a schema created for user to do this workI they already have a general purpose schema, can they create a role to have full DDL: rights in that schema?
I need to create a forgot password page in which there will be two text box named user name and email id and user will provide his usename and email id in those text box. so apex will check that the provided name and email id are there in the data base and if email id corresponds to right user name then a mail will be send to that email Id containing auto generated password.
View 1 Replies View Relatedhow 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- 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 .
I created a form to create a username and password.i tried creating a user in forms 6i using the following code on the when button pressed trigger:
BEGIN
forms_ddl('create user'||:user_name||'identified by'||:pasword);
commit_form;
END;
i have granted the user to create user but it does not work at all. password and user_name are captured in the form.
I am creating a procedure oracle forms and database Which one is fires first ..If suppose i need data base fires first...
View 3 Replies View RelatedI built a form in 10g and I want to replace the oracle menu with my menu, so I wrote the code
replace_menu('TA_MENU.MMX',null, null);
in the new form instance trigger but when I run the form it gave me this error
"frm-10221 can not read the fiel TA_MENU".
what have I do to fix this error?
Is there a way to start a new browser session from a call in an existing 11g form. I have a situation where in the client / server world I open a form in a new window .
View 1 Replies View RelatedI am facing a problem while creating a program using oracle forms.These two table i am using in creating following program .
SQL> desc electricity ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME VARCHAR2(40)
PREV_READING NUMBER(20)
PRESENT_REDAING NUMBER(20)
TOTAL_UNITS NUMBER(30)
AMOUNT NUMBER(30)
[code]....
What i want that whenever user writes a value in "PRESENT_Reading" Column then it stores value in "ID table" .For example if current month is July ,Then when user write a value in present Reading column ,it stores it in JULY Column of Id table ..i Write following trigger (Key_commit) On present_reading Column .
if sysdate=to_char(sysdate,'MON','Jan') Then
:electricity.PRESENT_REDAING := :ID.Jan ;
elsif
sysdate=to_char(sysdate,'MON','FEB') Then
:electricity.PRESENT_REDAING := :ID.Feb ;
elsif
sysdate=to_char(sysdate,'MON','MAR') Then
:electricity.PRESENT_REDAING:= :ID.MAR ;
But when i run my form it does not work ,and raised unhandled Exception .I think i need to change some properties of PRESENT_READING column of electricity table.
I want to create a Menu in my form .
First i create a form in Form Style using emp data block . Then , I create a Menu with two items . Then i compile and save both of them . But when i run my form , Menu does not appear .
Following
create or replace view dept_list as
select 1 state, 1 depth, 'DEPARTMENT' displ_value, null icn, null pk, 'A' sort_value
from dual
union
select -1 state, 2 depth, dname displ_value, null icn, null pk, 'A' sort_value
from dept
union
select -1 state, 3 depth, 'EMPLOYEES' displ_value, null icn, null pk, 'A' sort_value
from dept;
is placed in Pre_Form Trigger it generated error.
Error 103 at line 1, column 1
Encountered the symbol "create" when expected the following.
I have created searching tool using oracle forms 6i. while searching the cursor move from text field (A) to other block query the data according to the field (A) and come back again to field (A). Everything is working fine but the problem is, when the cursor move back to the field (A) the existing text is highlighted and when user right something in it. It's overwriting the existing text.
I want when the cursor moving bank to the field (A) the text should not be highlighted and when the user writes something that will be added to the existing text.
Oracle Developer Suite 10g
I want to create List item with time .
like in pic when I click on upper side at list item increase time and other side decrease time.
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 RelatedI want to raise a alert after the records retrieved from a query. i.e, if the query fetches 0 records then the alert show be displayed. Is is possible? If yes tell me the trigger to be used to raise such kind of alert.
View 4 Replies View RelatedI have installed Weblogic Server 10.3.6 in my PC .While in installation i have chosen 'Custom' option instead of 'Typical' and Unchecked software Components 'Database Evaluation' and 'Oracle Coherence' and Installed 'Node Manager Service' then continued with Weblogic server installation .Weblogic Server installed Succesfully.
(In weblogic server home folder nodemanager.domains file also not created after weblogic server installation)
Now i started installation of Forms and Reports 11g R2 . While Configuring Instance 'Domain Creation is Failed'.
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.
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.
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.
I'm trying to get client IP Address and show it to the user. I'm using forms 10g, with application server under UNIX.
View 1 Replies View RelatedHow to know which user is using which form.I am using form 6i and Oracle 10g a database.
View 3 Replies View Related