RE: Setting profile limits?
Title: Setting profile limits? Thanks for the help, or should I say the lack of help :) I took the disdainful silence from all of you, to mean that I had not done enough RTFM. Anyway a little experimentation on the test system and Rachel's 101 book managed to clear that problem. Thanks Bernardus for your input. Regards Denham -Original Message-From: Bernardus Deddy Hoeydiono [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 09, 2003 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Setting profile limits? Dear Denham Eva, Can explain more detail about the profile limit ? Because, based on my experiance The profile limit on oracle is wworking properly. Everything you have to create one profile first using command line or you can create the profile using DBA studio or TOAD (third party of Oracle from Quest Software). CREATE PROFILE test LIMIT SESSIONS_PER_USER XXX CPU_PER_SESSION XXX CPU_PER_CALL XXX CONNECT_TIME XXX IDLE_TIME XXX After you create the profile you just alter the corresponding user to the profile that you have set and created. alter user username profile profile_name; After you finish all the things above, you can test. And I believe it's working, becuase I have used before. Thanks, Bernardus Deddy Hoeydiono. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Denham EvaSent: Thursday, January 09, 2003 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: Setting profile limits? Hello List, I am not sure I understand the documentation correctly, please help out here. Lets assume that I have set RESOURCE_LIMIT to TRUE. Now I set the parameter IDLE_TIME for the profile DEFAULT. Here is the question: Does that mean that all the other parameters ie CONNECT_TIME, SESSION_PER_USER, CPU_PER_SESSION etc remain the same as before the changes? Or will I be forced to change or set all the parameters? Thanks in advance for the help. Regards Denham Eva Oracle DBA "UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity." Dennis Ritchie. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: Setting profile limits?
Title: Setting profile limits? Dear Denham Eva, Can explain more detail about the profile limit ? Because, based on my experiance The profile limit on oracle is wworking properly. Everything you have to create one profile first using command line or you can create the profile using DBA studio or TOAD (third party of Oracle from Quest Software). CREATE PROFILE test LIMIT SESSIONS_PER_USER XXX CPU_PER_SESSION XXX CPU_PER_CALL XXX CONNECT_TIME XXX IDLE_TIME XXX After you create the profile you just alter the corresponding user to the profile that you have set and created. alter user username profile profile_name; After you finish all the things above, you can test. And I believe it's working, becuase I have used before. Thanks, Bernardus Deddy Hoeydiono. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Denham EvaSent: Thursday, January 09, 2003 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: Setting profile limits? Hello List, I am not sure I understand the documentation correctly, please help out here. Lets assume that I have set RESOURCE_LIMIT to TRUE. Now I set the parameter IDLE_TIME for the profile DEFAULT. Here is the question: Does that mean that all the other parameters ie CONNECT_TIME, SESSION_PER_USER, CPU_PER_SESSION etc remain the same as before the changes? Or will I be forced to change or set all the parameters? Thanks in advance for the help. Regards Denham Eva Oracle DBA "UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity." Dennis Ritchie. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
Setting profile limits?
Title: Setting profile limits? Hello List, I am not sure I understand the documentation correctly, please help out here. Lets assume that I have set RESOURCE_LIMIT to TRUE. Now I set the parameter IDLE_TIME for the profile DEFAULT. Here is the question: Does that mean that all the other parameters ie CONNECT_TIME, SESSION_PER_USER, CPU_PER_SESSION etc remain the same as before the changes? Or will I be forced to change or set all the parameters? Thanks in advance for the help. Regards Denham Eva Oracle DBA "UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity." Dennis Ritchie. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: Understanding CPU time and profile
So what if the user is using PQO? Would this control the total (sum) of all the CPU time used by all processes involved in the query? Waleed -Original Message- Sent: Thursday, November 28, 2002 4:59 PM To: Multiple recipients of list ORACLE-L I'm testing profile to limit end users doing ad-hoc queries. I have a query that is taking 51740 cpu unit according to v$sesstat. In the doc, the unit is "Amount of CPU time (in 10s of milliseconds)" so its 517 seconds. I've created a profile with cpu_per_call limit of 3000, the unit is in hundredths of seconds, so 30 seconds. Once the profile created the query fails and when I checked the cpu in v$sesstat it went from 10692 to 21547 so 10855 so 108 seconds. It should have been around 30 seconds, no ? = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Understanding CPU time and profile
I'm testing profile to limit end users doing ad-hoc queries. I have a query that is taking 51740 cpu unit according to v$sesstat. In the doc, the unit is "Amount of CPU time (in 10s of milliseconds)" so its 517 seconds. I've created a profile with cpu_per_call limit of 3000, the unit is in hundredths of seconds, so 30 seconds. Once the profile created the query fails and when I checked the cpu in v$sesstat it went from 10692 to 21547 so 10855 so 108 seconds. It should have been around 30 seconds, no ? = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anybody using profile to limit ressources
On 817/aix, the end-users will have access to query data in an ad-hoc fashion. We want to limit the problems. I want to limit per queries so I guess that I must used cpu_per_call. I'm currently testing some queries and checking statistics CPU used when call started to see how much a query consumes. CPU used when call started and CPU used by this session shows the same value, I thought there would be different. Anybody using profile to limit ressources ? = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Profile
Good Morning, Is there much/any overhead associated with turning the resource_limit on and enacting profiles to limit user resources? Thanks, Joe Frohne UW-Milwaukee, DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: profile
DBMS_RESOURCE_MANAGER does just that. See tha manual (supplied PL/SQL packages reference) and Metablink. On 2002.06.04 04:08 Otakar Mouèka wrote: > Hello guru > How can I set a performance of CPU for 1 session at 15 % in profile > I hawe Oracle 8.1.7 . R 3 . > Thanks Oto > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Otakar =?iso-8859-2?q?Mou=E8ka?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: profile
Set Resource_Limit = TRUE in the Parameter File. Then Create a Profile that uses Cpu_Per_Call and CPU_Per_Session values so that CPU Usgae is restricted. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 04, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Hello guru How can I set a performance of CPU for 1 session at 15 % in profile I hawe Oracle 8.1.7 . R 3 . Thanks Oto -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Otakar =?iso-8859-2?q?Mou=E8ka?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
profile
Hello guru How can I set a performance of CPU for 1 session at 15 % in profile I hawe Oracle 8.1.7 . R 3 . Thanks Oto -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Otakar =?iso-8859-2?q?Mou=E8ka?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Profile Usage Curiosity (WAS) Re: user holding session even after a re-boot
On Wed, 15 Aug 2001, [EMAIL PROTECTED] wrote: > I was talking about the connection profiles that you can use to > set resource limits when you run the > > create profile > > command. > > With this you can create a profile for a set of users that you > can then attach to a user either when you create it or thru the > alter user command. > > The profile lets you set such things as CONNECT_TIME and > IDLE_TIME. Maybe the IDLE_TIME setting might let those > processes drop off. I haven't actually used these before. I have always just had a couple of application users which were defined for the needs of applications. Was curious to hear some others give overviews on how and why have people used these. They seem to be a very good way to control access when you have a large number of people that will be accessing your database through an ad-hoc tool, like sqlplus, instead of a specific application. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Linux profile - a little offtopic
Hi . profile and its associates for the other shells need only be read only for the user. It is common behavior on a production server to have the majority of users profiles linked to a central profile file so it is only editable by the System Admin. This keeps a potential security hole at bay by not allowing users access to the .profiles or whatever you use for the user shell. If the changes to .profile are not changing your shell then you are using a different shell. On Linux you will be almost certainly using bash by default so you will need to put changes in .bashrc or maybe .bash_profile HTH Peter At 08:55 PM 1/07/2001 -0800, you wrote: >Kimberly, > >Since .profile is of little use unless sourced, >why make it executable? > >Maybe I missed something here, but I've never used >an executable .profile. > >Jared > >On Sunday 01 July 2001 11:15, Kimberly Smith wrote: > > Also, make sure the .profile is executable. It isn't by default > > usually. Also make sure the oracle account is setup to use a shell > > that the .profile actually applies to. For example, ksh (my personal > > favoriate). C shell uses the .login. > > > > -Original Message- > > Sent: Saturday, June 30, 2001 10:20 AM > > To: Multiple recipients of list ORACLE-L > > > > On June 30, 2001 01:30 pm, Csillag Zsolt wrote: > > > Hi, > > > > > > Since I'd like to install Oracle for Linux, I need to change the > > > profile for user 'oracle'. > > > > > > I edited the .profile file located in /home/oracle folder but it > > > seems to me that this isn't the file that Linux loads at startup. > > > > Take a look at /etc/profile - this is the default system-wide user > > profile (be aware that all changes to this file will affect all > > non-root users on the system). > > > > Cheers, > > GC >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jared Still > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Linux profile - a little offtopic
Kimberly, Since .profile is of little use unless sourced, why make it executable? Maybe I missed something here, but I've never used an executable .profile. Jared On Sunday 01 July 2001 11:15, Kimberly Smith wrote: > Also, make sure the .profile is executable. It isn't by default > usually. Also make sure the oracle account is setup to use a shell > that the .profile actually applies to. For example, ksh (my personal > favoriate). C shell uses the .login. > > -Original Message- > Sent: Saturday, June 30, 2001 10:20 AM > To: Multiple recipients of list ORACLE-L > > On June 30, 2001 01:30 pm, Csillag Zsolt wrote: > > Hi, > > > > Since I'd like to install Oracle for Linux, I need to change the > > profile for user 'oracle'. > > > > I edited the .profile file located in /home/oracle folder but it > > seems to me that this isn't the file that Linux loads at startup. > > Take a look at /etc/profile - this is the default system-wide user > profile (be aware that all changes to this file will affect all > non-root users on the system). > > Cheers, > GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Linux profile - a little offtopic
Also, make sure the .profile is executable. It isn't by default usually. Also make sure the oracle account is setup to use a shell that the .profile actually applies to. For example, ksh (my personal favoriate). C shell uses the .login. -Original Message- Sent: Saturday, June 30, 2001 10:20 AM To: Multiple recipients of list ORACLE-L On June 30, 2001 01:30 pm, Csillag Zsolt wrote: > Hi, > > Since I'd like to install Oracle for Linux, I need to change the > profile for user 'oracle'. > > I edited the .profile file located in /home/oracle folder but it > seems to me that this isn't the file that Linux loads at startup. Take a look at /etc/profile - this is the default system-wide user profile (be aware that all changes to this file will affect all non-root users on the system). Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Linux profile - a little offtopic
hi, In linux it is bash shell and you have to change you bash_profile of oracle and not the .profile file. check that out Csillag Zsolt wrote: > Hi, > > Since I'd like to install Oracle for Linux, I need to change the profile for > user 'oracle'. > > I edited the .profile file located in /home/oracle folder but it seems to me > that this isn't the file that Linux loads at startup. > > T.I.A. > > Zsolt Csillag, > Hungary > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Csillag Zsolt > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Linux profile - a little offtopic
also, try man bash (or whatever your shell is). It will explain what files are sourced under which circumstances. george On Saturday, June 30, 2001, at 01:20 PM, Gregory Conron wrote: > On June 30, 2001 01:30 pm, Csillag Zsolt wrote: >> Hi, >> >> Since I'd like to install Oracle for Linux, I need to change the >> profile for user 'oracle'. >> >> I edited the .profile file located in /home/oracle folder but it >> seems to me that this isn't the file that Linux loads at startup. > > Take a look at /etc/profile - this is the default system-wide user > profile (be aware that all changes to this file will affect all > non-root users on the system). > > Cheers, > GC > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gregory Conron > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Linux profile - a little offtopic
What shell are you using? Different shell uses different startup filename. If you are using bash, then it's .bashrc >>> [EMAIL PROTECTED] 06/30/01 12:30PM >>> Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. T.I.A. Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Linux profile - a little offtopic
On June 30, 2001 01:30 pm, Csillag Zsolt wrote: > Hi, > > Since I'd like to install Oracle for Linux, I need to change the > profile for user 'oracle'. > > I edited the .profile file located in /home/oracle folder but it > seems to me that this isn't the file that Linux loads at startup. Take a look at /etc/profile - this is the default system-wide user profile (be aware that all changes to this file will affect all non-root users on the system). Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Linux profile - a little offtopic
Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. T.I.A. Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Product user profile & 3rd patry product
Hi, If you are using Oracle8i, there is a way to do this. Review the following post: On Thu, 6 Jan 2000, Joseph Testa wrote: > Why would you want to do that, well, i'm at a place where the developers > have the schema owner password but we DBAs(being retentitive as we are)dont > want them to make any ddl changes. > > > here are the steps: > > Feel free to change the names to your liking > > create user schema_control identified by > grant create any trigger to schema_control; > > edit the 3 following triggers, changing the to the schema you > want to put the control on: > > create or replace trigger create_control_trigger > before create on .schema > > begin > raise_application_error(-20001,'NO CREATE DDL ALLOWED'); > end; > / > > create or replace trigger drop_control_trigger > before drop on .schema > > begin > raise_application_error(-20001,'NO DROP DDL ALLOWED'); > end; > / > > create or replace trigger alter_control_trigger > before alter on .schema > > begin > raise_application_error(-20001,'NO ALTER DDL ALLOWED'); > end; > / > > > revoke alter any trigger from ; > > the previous line is needed so they dont alter the trigger to disable it :) > > the next time they attempt to create, drop or alter anything in that schema > they get error msg. > > This all assumes they are not dba :) > > hht, joe > Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Brijesh Satdev [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, June 14, 2001 12:11 AM > To: Multiple recipients of list ORACLE-L > Subject: Product user profile & 3rd patry product > > Hi all, > > We have a third party product namely a drafting utility called > microstation > which requires connectivity to some schema in the database. > > It is neccesary for the database user to have create table system > priviledge, but I want to restrict end users from deleting tables from > this > schema through microstation (there is a in built sql editor in > microstation). > > I checked the product_user_profile table and it only seems to work for > Sql*plus. > > Is there some other way to control the situation, as this poses a very > high > security risk for the database. > > I appreciate your time and effort. > > Regards, > Brijesh. > DBA Rolta India Ltd. > OCP Oracle8 DBA. > > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Product user profile & 3rd patry product
Hi all, We have a third party product namely a drafting utility called microstation which requires connectivity to some schema in the database. It is neccesary for the database user to have create table system priviledge, but I want to restrict end users from deleting tables from this schema through microstation (there is a in built sql editor in microstation). I checked the product_user_profile table and it only seems to work for Sql*plus. Is there some other way to control the situation, as this poses a very high security risk for the database. I appreciate your time and effort. Regards, Brijesh. DBA Rolta India Ltd. OCP Oracle8 DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Satdev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).