Server Administration :: Insert User ID Automatically In Table?

May 7, 2010

I have a table with table_ID, date_created, user_id.

I have sequence, and a BEFORE INSERT trigger, which uses the seq to increment the table_ID by 1, everytime the webpage is saved.

ques:
(1).If i have date_creted defaulted to sysdate in the table, do I need to have it in the trigger?
-- Update create_date field to current system date
:NEW.DATE_CREATED := sysdate;

(2).How can I insert the user_id in the table, each time user SAVE the page ? web page procedure is getting the user info at the beginning. can i add it in the trigger

DECLARE
v_username varchar2(10);
BEGIN

[Code]....

View 1 Replies


ADVERTISEMENT

Forms :: Insert Date And Time Automatically In Table

Apr 29, 2013

i have emp table of 5 columns empno,ename,dept,sal,edit_timing(edit timing datatype is timestamp).and my form contains empno,ename,dept,sal. is if i insert a record into forms it automatically insert the date and timing into edit_timing columns.

View 2 Replies View Related

Server Administration :: Flashback Table Operation For The Sys User

Jun 7, 2010

Flashback table operations are not supported for the SYS user . I have found the above line in one of the article.

I don't know why the SYS user can not able to flash back the table.

View 5 Replies View Related

Server Administration :: Unable To Drop User - Table Or View Does Not Exist

Jun 6, 2011

Im facing the problem whenever I try to drop a user. Following thing that I m trying..

system@vahan> drop user knp cascade;

Error at line 1:
ORA-00604: error occured at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7

View 4 Replies View Related

Server Administration :: Server Down Automatically After Every Half An Hour Or 15 Min

Feb 4, 2010

the reason why this happen with our server.

View 4 Replies View Related

Server Administration :: Session Closed Automatically?

May 22, 2012

One user complained that, his session is closing automatically when his session exceeds exactly 01 hour 1 minute.

default profile is assigned for this user. I checked the idle_time value of this default profile. it is UNLIMITED only. What else I need to check to find out is there any timeout parameter has been set or not?

View 6 Replies View Related

Server Administration :: Database Is Not Getting Started Automatically?

Sep 3, 2010

I have oracle 8i installed on a Windows XP with SP2 PC. Everytime i start the pc the database is not getting started automatically however i need to start it manually using the svrmgrl command. How to autostart the database.

View 1 Replies View Related

Server Administration :: MView Not Refreshing Automatically At Time Interval Specified?

Sep 14, 2011

I have create a mview using a dblink with the refresh difference of every 10min. Suddenly I check the mview refresh date and time it was not getting refreshed automatically at the time interval specified.

drop MATERIALIZED view log on afccv.tbl_voicechat;
drop MATERIALIZED VIEW SMSCHAT.TBL_VOICECHAT_NEW1 ;
CREATE MATERIALIZED VIEW SMSCHAT.TBL_VOICECHAT_NEW1
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

[code]....

I am trying to find out what is the cause of not refreshing and also googled for the same. got some link also either not linked to same problem or not cleared.. Where should i checked regarding the error cause.

View 33 Replies View Related

Server Administration :: DB Shutting Down Automatically By Terminating Smon Process

Dec 22, 2010

I have a db on 10.2.0.1 and it's going down automatically after some time with the error in alert log file smon process terminating.

View 3 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

Reports & Discoverer :: Value In Table Column Based On Some Existing Column Value Automatically Without User Intervention

May 15, 2011

i have two questions.

(1) how can i fill some value in a table column based on some existing column value automatically without user intervention. my actual problem is i have 'expiry date' column and 'status'. the 'status' column should get filled automatically based on the current system date. ex: if expiry date is '25-Apr-2011' and current date is '14-May-2011', then status should be filled as 'EXPIRED'

(2)hOw can i build 'select' query in a report (report 6i) so that it will show me list of items 'EXPIRED' or 'NOT EXPIRED' or both expired and not expired separately in a single report based on user choice. 'EXPIRED' & 'NOT EXPIRED' can be taken from the above question no. 1.

View 3 Replies View Related

Server Administration :: Externally Authenticated User Login Syntax As Proxy User?

Nov 15, 2010

I created an externally authenticated user in database. And can login without password with below syntax.

SQL> connect / @TESTDB
Connected.
SQL> show user;
USER is "SCOTT"

This scott user has a proxy permission to another DBuser PROXY_USER. Previously I used to login using below syntax.

connect scott[proxy_user]/password_for_scott@TESTDB

So now, what syntax should be used for this "ExternallY Authenticated" user to login as a proxy user?

View 10 Replies View Related

Server Administration :: Creating A View In User From Another User?

Nov 9, 2011

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"

View 12 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

Forms :: Inserting ID / SYSDATE And USER Automatically?

Aug 5, 2010

I have created a datablock and set up the user interface to allow the users to insert all the data they need, however my table has some fields which should be generated automatically and are not done through user input:

id - which is uniqe to each entry to the table so is gernerate by a sequence (which I created on the database) but when i put seq.nextval into the initial value on the datablock it says i cannot do this, so how do I use the sequence to insert the value into that field in the database. This is my primary key in my database whichobviosuly my users cant input data to, instead it is generated automatically.

User - similarly in the datablock is a user field which states the user that inserted that record, I know on the database i can put DEFAULT user for that field , but how do I make the user insert automatically through forms.

Date - Similarly again how do I set SYSDATE to be automatically input to the date field when the user submits the record?

View 8 Replies View Related

Application Express :: How To Create Automatically Item If Value Insert Into Masters

Oct 14, 2013

 i have create service rate card Form for transport Service and i have declare transport component into master lookup table .There is 11 component into master.To Difine rate for a particular transport service i have insert these component name with there rate into another table transport_rate _card.

 To do this i have created page with these 11 component name item and there 11 rate item to enter component rate  with respective services. Problem is if i create 11 component name text item and 11 text item to enter there conmponent rate but if user add 3 or 4 or 5 more componenet name into master then i'll be need to add extra component name text item and component rate text item.so i need to create form where if user add more component into master then component name item and component rate item should be increase automaticaly. 

How i can create form where item added auotmaticaly acording to component which are exist into master table. there is only component name into master table. 

View 9 Replies View Related

PL/SQL :: Create Trigger To Insert Data From One User To Another User In Same Database?

Apr 16, 2013

I Created One Trigger as Follows

CREATE OR REPLACE TRIGGER TRIGGER1
BEFORE INSERT
ON table1
FOR EACH ROW

[code]......

Here , I Want To Insert The Data From My User To Test User . In This Situation When I Execute The Above Trigger It Shows The Error PL/SQL: ORA-00942: table or view does not exist

View 3 Replies View Related

Server Administration :: User ID Fetching

Sep 22, 2011

In my project a user has updated a column with wrong value which had caused some issues.

I wish to find the userid of person who did the update on the table.

There is no trigger on that table

I used the following queries but have not got success

select * from USER_TAB_modifications where table_name like '%XYZ%';

select * from USER_AUDIT_OBJECT ;

I WAS ABLE TO GET WHEN LAST UPDATE TOOK PLACE on table but not userid details

View 1 Replies View Related

Server Administration :: Oracle RAC ASM User?

Sep 20, 2011

We have installed Oracle RAC 11gR2, installation was all successful.But i cannot see ASMSNMP user to login as ASM enterprise manager .If i tries to login as sys (even after assigning SYSASM role) he cannot login.

Quote:Set Oracle_sid=+ASM1
sqlplus / as sysasm
grant sysasm to sys;
conn sys/*** as sysasm
ORA-01031 insufficient privileges

View 3 Replies View Related

Server Administration :: Object Created In Different User?

Jul 15, 2010

Whenever I create a table using login A, the table gets created successfully. But when I query the dba_objects, the object owner is different, login B. What might be the reason behind this?

View 9 Replies View Related

Server Administration :: Error While Dropping User?

Mar 30, 2012

Got following error while droping user

DB:9.2.0.8.0 OS:Windows 2003

SQL> drop user custom cascade;
drop user custom cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-21700: object does not exist or is marked for delete

View 1 Replies View Related

Server Administration :: PGA Memory For Every User Or Every Session

Mar 18, 2013

I need to ask about PGA memory. Is this memory for every user or every session

i.e. PGA 200M

I have 2 users with 300 connection with one of them. Is 200M for 300 connection or for every connect.

View 2 Replies View Related

Server Administration :: DB Link For One To Many User Access

Sep 14, 2010

I need to create one to many user DB link in oracle 10g. Meaning I have a user A in database 1 and I want to access the objects from user B,C,D in database 2, how to create a public database link so that i can have this one to many user access?

View 8 Replies View Related

Server Administration :: Number Of Connection For A User

Aug 27, 2013

How to determine number of connections establishing from application server to database server for a particular user and also query the user is running in database.

user -- application user created in database.
same user exist in application.

View 15 Replies View Related

Server Administration :: Assign User Roles To Uses?

Aug 19, 2011

Is there any default way to assign user roles to uses ?

Suppose I want assign to user different roles to different users on views, tables etc.

I wan to implement Access control list & Access request objects (ACL/ARO).

View 7 Replies View Related

Server Administration :: Precautions Before Drop User

Jul 28, 2011

I want to drop some users which are no longer been used .What are the precautions i need to take before i drop users? I have taken logical backup (Export) of users i want to drop.Is there anything i missed out before i drop user?

View 4 Replies View Related

Server Administration :: User Login Fails?

Sep 27, 2011

I just create a user and tried to log in but it gives the following error, why?

SQL*Plus: Release 10.1.0.4.2 - Production on Tue Sep 27 10:57:55 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> create user user1 identified by user1;

User created.

SQL> conn user1
Enter password: *****
ERROR:
ORA-12560: TNS:protocol adapter error

Warning: You are no longer connected to ORACLE.

View 26 Replies View Related

Server Administration :: Insufficient Privileges To Other User

May 21, 2011

WHEN I CONNECT TO SCOTT OR ANY KIND OF USER (EXCLUDE SYS)I CONNECT EASILY BUT PROBLEM WITH SCOTT OR OTHER THEY CANNOT BE
SHUTDOWN THE DATABASE AT THAT TIME THE ERROR ARISES ARE

ORA-01031: insufficient privileges SO OUR DATABASE CANT BE SHUT IT DOWN.

View 5 Replies View Related

Server Administration :: Create User Email

Mar 22, 2011

I want whenever a user is created in database the server send me a mail about this.

View 3 Replies View Related

Server Administration :: Connect 9i To 10g With Same Database And User?

Oct 19, 2012

last two years i am using oracle 9i in windows 2003 server but now i installed oracle 10g on another server (PC) , i want to connect 9i to 10g with same database and user .

View 3 Replies View Related







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