You can create the synonyms as public without a security problem. It all depends on who has select priviledges on those tables. ... From: joness59...
855
Bharat Sharma, PSFT
sharmacentral
Feb 16, 2005 1:32 pm
If the current session is altered.. who will get audited - the developers ID or SYSADM? Bharat Sharma. IJIT Inc. ... From: Wolfgang Breitling...
856
R P
pjksel
Feb 16, 2005 5:10 pm
Hi, I have heard that creating synonyms can cause a peformance degradation in certain versions of Oracle. Not sure if that still applies, but it may be worth...
857
ricky_parham@...
wreekie
Feb 16, 2005 10:53 pm
I like the idea of this trigger. Do you mind sharing your code for creating the trigger. Thanks, - Ricky ... logon ... and I ... that ... have to ... create ...
858
ikingus
Feb 16, 2005 10:53 pm
Hi. Does anyone have a suggestion to get by PER099 AppEngine process quickly? This process is taking too long (29 hours so far) and I need to find a way to...
859
joness59
Feb 16, 2005 10:53 pm
I tried the following and it doesn't seem to work: I have a role called PSADMIN which has been granted 'grant any role' priv. I have schema owner SYSADM which...
860
Wolfgang Breitling
wolfgang_bre...
Feb 17, 2005 3:40 am
At 04:14 PM 16/02/2005, you wrote: Couldn't be simpler: create or replace trigger logon_trg after logon on schema begin execute immediate 'alter session set...
861
Paul Reji
prphilip
Feb 18, 2005 1:19 am
All I am an oracle dba, recently assigned to a peoplesoft migration. I got a backup file and i am to make this application up and running on a test box in a...
862
Laurent LCU. CORNILLEAU
manaiti2000
Feb 18, 2005 1:00 pm
Hi Paul, What version of peopletools do you use ? You have not only to set up the webserver but the application server as well (Tuxedo). Regards, Laurent ... ...
863
Paul Reji
prphilip
Feb 18, 2005 8:14 pm
Thank you for your help here are the information we run 8.0 HRMS Engine w/8.1.4 PeopleTools. Oracle version 8.1.6 the directories created are app/Weblinst ...
864
Paul Reji
prphilip
Feb 18, 2005 8:14 pm
Thanks for replying here is more info the following directories were created app/Weblinst app/aux109 app/psoft app/psreports app/sqr614 app/sqrinst app/tuxedo ...
865
jimbohva
Feb 19, 2005 6:28 am
Hi, Getting a lot of warnings in my event viewer. Forced shutdown of client; user name 'PS'; client name 'JavaClient' and many other user names. This is on...
866
Laurent LCU. CORNILLEAU
manaiti2000
Feb 21, 2005 11:58 am
Hi Jim, Don't worry about that, these messages are quite normal. Since application server's timeout runs, client session expires by "forced shutdown". Laurent ...
867
Ruth Bittinger
ruth.bittinger@...
Feb 22, 2005 5:05 am
Hi, I've created a trigger on psprcsrqst in an HR8 database (running on Oracle 8.1.7.4) using the script on p. 270 of David Kurtz' book PeopleSoft for the...
868
David Kurtz
davidkurtz
Feb 22, 2005 6:06 am
There is probably an error being raised in the trigger. However, the exception prevents the trigger from causing the update to fail, otherwise it could in...
869
Ruth Bittinger
ruth.bittinger@...
Feb 22, 2005 4:22 pm
Sorry, I should have included this in the first post: create or replace trigger sysadm.set_trace_psppyrun before update of runstatus on sysadm.psprcsrqst for...
870
sriniraghuraman
Feb 23, 2005 10:02 pm
This is Related to Sendmail Question. If i have 12 email id (xxxx@...) in the &mail_to list and use sendmail(...),it sends good, but 12 email id will show ...
871
Ruth Bittinger
ruthbittinger
Feb 28, 2005 3:32 pm
Thank you very much! The trigger was raising an error, and it was "ORA-01031: insufficient privileges". The comment in the header of the create trigger...
872
Wolfgang Breitling
wolfgang_bre...
Feb 28, 2005 3:33 pm
For everybody's information. I have been communicating with Ruth directly and it turned out to be that the alter session privilege needed to be granted to...
873
Rimpal Johal
rimpal_johal
Mar 1, 2005 11:39 pm
Hi All, Using tmadmin, command line interface for administering the application server domain, we can manually start and stop the individual server...
874
Wolfgang Breitling
wolfgang_bre...
Mar 2, 2005 4:54 am
You can process the PSTUXCFG into a human readable form with tmunloadcf and look up the srvid for the different servers. That is the starting point. Then you...
875
David Kurtz
davidkurtz
Mar 2, 2005 5:09 am
Or, you could just look at the psappsrv.ubb which is used to produce the compiled Tuxedo configuration file. The output of tmunloadcf shows you all the Tuxedo...
876
David Kurtz
davidkurtz
Mar 3, 2005 9:18 am
Hello Everyone I am planning to make a change to the moderation policy on the PSFTDBA group. Instead of allowing anyone to join and manually moderating all...
877
sharad bansal
sharadbansal
Mar 3, 2005 10:01 am
This is right David Regards Sharad Bansal Peoplesoft DBA O2, Germany David Kurtz <info2@...> wrote: Hello Everyone I am planning to make a change...
878
Gerry Leith
gerryleith
Mar 3, 2005 10:29 am
David Support you completely. Gerry ... From: David Kurtz [mailto:info2@...] Sent: Thursday, March 03, 2005 8:57 To: psftdba@yahoogroups.com ...
879
Phillip Eaton
pjeaton
Mar 3, 2005 10:36 am
Sounds good to me. I thought you already did approve new members! ... From: Gerry Leith [mailto:gerry@...] Sent: 03 March 2005 10:29 To:...
880
Anand Vashta
anand_vashta
Mar 3, 2005 11:17 am
Yes it will help to reduce spam ... <http://us.ard.yahoo.com/SIG=129iu1mrr/M=298184.6018725.7038619.3001176/D=gr ... ...
881
michael.ngong@...
Mar 3, 2005 1:20 pm
Greetings I manually added tablespaces to a database and those tablespaces are not reflected when I query ddlspacename from psrecdefn. Is this something to...
882
Goulet, Dick
dgoulet@...
Mar 3, 2005 1:56 pm
Anything to kill off some of the spam! _____ From: Gerry Leith [mailto:gerry@...] Sent: Thursday, March 03, 2005 5:29 AM To:...
883
Baird, Andrew (ICT) (...
bairdclan
Mar 3, 2005 2:36 pm
Right behind you on that one. Andy ... Van: David Kurtz [mailto:info2@...] Verzonden: donderdag 3 maart 2005 09:57 Aan: psftdba@yahoogroups.com ...
