Re: ARADMIN user Roles for ARSYSTEM on 7.5
Jarl, Its the 3rd and 4th step that I was missing, thanks for pointing me to that. I got an email from Remedy Support regarding the same at about the same time I heard from you, so thanks for the info anyways. Another somewhat related questions to those more familiar with setting up ARS on a Windows server. At the time of running the install, any idea where the ar_install.log file gets created? I did look in the C:\Windows\Temp directory, but didn't see any familiar files there.. Joe From: Jarl Grøneng jarl.gron...@gmail.com To: arslist@ARSLIST.ORG Sent: Friday, July 10, 2009 3:05:22 PM Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 From the install guide; (oracle) To use a previously created tablespace in AR System 1 In an SQL*Plus window, create the tablespace. For example: create tablespace arsys datafile 'c:\qa\data\QATST\data\arsys.dbf' size 500M reuse; 2 Create a user. For example: create user aradmin identified by AR#Admin# default tablespace arsys temporary tablespace temp quota unlimited on arsys; 3 Create a role for the user you created. For example: create role ARole_arsys not identified; 4 Set the privileges for the role. For example: grant alter session, create cluster, create database link, create sequence, create session, create synonym, create table, create view, create procedure, create trigger, query rewrite to ARole_arsys; 5 Grant the role to the user. For example: grant ARole_arsys to aradmin; 2009/7/10 Joe DeSouza joe_rem...@yahoo.com: To the best of my knowledge the previous versions it was enough to have full CONNECT (with the Admin Option) and the DBA (with the Admin option) for the ARADMIN user.. Have some more roles been added to 7.5? I do not have the documents handy right now to check so someone could kindly verify this for me? Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARADMIN user Roles for ARSYSTEM on 7.5
Hi Joe, Try looking in InstallDrive:\Program Files\BMC Software\ARSystem\Logs HTH Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, July 13, 2009 9:04 AM To: arslist@ARSLIST.ORG Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 ** Jarl, Its the 3rd and 4th step that I was missing, thanks for pointing me to that. I got an email from Remedy Support regarding the same at about the same time I heard from you, so thanks for the info anyways. Another somewhat related questions to those more familiar with setting up ARS on a Windows server. At the time of running the install, any idea where the ar_install.log file gets created? I did look in the C:\Windows\Temp directory, but didn't see any familiar files there.. Joe _ From: Jarl Grøneng jarl.gron...@gmail.com To: arslist@ARSLIST.ORG Sent: Friday, July 10, 2009 3:05:22 PM Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 From the install guide; (oracle) To use a previously created tablespace in AR System 1 In an SQL*Plus window, create the tablespace. For example: create tablespace arsys datafile 'c:\qa\data\QATST\data\arsys.dbf' size 500M reuse; 2 Create a user. For example: create user aradmin identified by AR#Admin# default tablespace arsys temporary tablespace temp quota unlimited on arsys; 3 Create a role for the user you created. For example: create role ARole_arsys not identified; 4 Set the privileges for the role. For example: grant alter session, create cluster, create database link, create sequence, create session, create synonym, create table, create view, create procedure, create trigger, query rewrite to ARole_arsys; 5 Grant the role to the user. For example: grant ARole_arsys to aradmin; 2009/7/10 Joe DeSouza joe_rem...@yahoo.com: To the best of my knowledge the previous versions it was enough to have full CONNECT (with the Admin Option) and the DBA (with the Admin option) for the ARADMIN user.. Have some more roles been added to 7.5? I do not have the documents handy right now to check so someone could kindly verify this for me? Joe _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARADMIN user Roles for ARSYSTEM on 7.5
I should have given more details :-) I would look there but that directory has not yet been created. I want to start reading the install logs the moment the installer kicks up. This is a new install, I'm seeing a couple of points of failures during the install and I wanted to see the 'temp' logs equivalent to those found in the /tmp or the /usr/tmp directory in UNIX during UNIX installs. Joe From: Leonard Neely - FOJ lne...@focusonjobs.com To: arslist@ARSLIST.ORG Sent: Monday, July 13, 2009 12:17:22 PM Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 ** Hi Joe, Try looking in “InstallDrive:\Program Files\BMC Software\ARSystem\Logs” HTH Leonard Neely From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, July 13, 2009 9:04 AM To: arslist@ARSLIST.ORG Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 ** Jarl, Its the 3rd and 4th step that I was missing, thanks for pointing me to that. I got an email from Remedy Support regarding the same at about the same time I heard from you, so thanks for the info anyways. Another somewhat related questions to those more familiar with setting up ARS on a Windows server. At the time of running the install, any idea where the ar_install.log file gets created? I did look in the C:\Windows\Temp directory, but didn't see any familiar files there.. Joe From:Jarl Grøneng jarl.gron...@gmail.com To: arslist@ARSLIST.ORG Sent: Friday, July 10, 2009 3:05:22 PM Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 From the install guide; (oracle) To use a previously created tablespace in AR System 1 In an SQL*Plus window, create the tablespace. For example: create tablespace arsys datafile 'c:\qa\data\QATST\data\arsys.dbf' size 500M reuse; 2 Create a user. For example: create user aradmin identified by AR#Admin# default tablespace arsys temporary tablespace temp quota unlimited on arsys; 3 Create a role for the user you created. For example: create role ARole_arsys not identified; 4 Set the privileges for the role. For example: grant alter session, create cluster, create database link, create sequence, create session, create synonym, create table, create view, create procedure, create trigger, query rewrite to ARole_arsys; 5 Grant the role to the user. For example: grant ARole_arsys to aradmin; 2009/7/10 Joe DeSouza joe_rem...@yahoo.com: To the best of my knowledge the previous versions it was enough to have full CONNECT (with the Admin Option) and the DBA (with the Admin option) for the ARADMIN user.. Have some more roles been added to 7.5? I do not have the documents handy right now to check so someone could kindly verify this for me? Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARADMIN user Roles for ARSYSTEM on 7.5
In that case, try looking in ” C:\Documents and Settings\Administrator\Local Settings\Temp\ arsystem_install_log.txt (assuming you are logged into the server as “Administrator”) Leonard From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, July 13, 2009 9:35 AM To: arslist@ARSLIST.ORG Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 ** I should have given more details :-) I would look there but that directory has not yet been created. I want to start reading the install logs the moment the installer kicks up. This is a new install, I'm seeing a couple of points of failures during the install and I wanted to see the 'temp' logs equivalent to those found in the /tmp or the /usr/tmp directory in UNIX during UNIX installs. Joe _ From: Leonard Neely - FOJ lne...@focusonjobs.com To: arslist@ARSLIST.ORG Sent: Monday, July 13, 2009 12:17:22 PM Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 ** Hi Joe, Try looking in “InstallDrive:\Program Files\BMC Software\ARSystem\Logs” HTH Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, July 13, 2009 9:04 AM To: arslist@ARSLIST.ORG Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 ** Jarl, Its the 3rd and 4th step that I was missing, thanks for pointing me to that. I got an email from Remedy Support regarding the same at about the same time I heard from you, so thanks for the info anyways. Another somewhat related questions to those more familiar with setting up ARS on a Windows server. At the time of running the install, any idea where the ar_install.log file gets created? I did look in the C:\Windows\Temp directory, but didn't see any familiar files there.. Joe _ From: Jarl Grøneng jarl.gron...@gmail.com To: arslist@ARSLIST.ORG Sent: Friday, July 10, 2009 3:05:22 PM Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 From the install guide; (oracle) To use a previously created tablespace in AR System 1 In an SQL*Plus window, create the tablespace. For example: create tablespace arsys datafile 'c:\qa\data\QATST\data\arsys.dbf' size 500M reuse; 2 Create a user. For example: create user aradmin identified by AR#Admin# default tablespace arsys temporary tablespace temp quota unlimited on arsys; 3 Create a role for the user you created. For example: create role ARole_arsys not identified; 4 Set the privileges for the role. For example: grant alter session, create cluster, create database link, create sequence, create session, create synonym, create table, create view, create procedure, create trigger, query rewrite to ARole_arsys; 5 Grant the role to the user. For example: grant ARole_arsys to aradmin; 2009/7/10 Joe DeSouza joe_rem...@yahoo.com: To the best of my knowledge the previous versions it was enough to have full CONNECT (with the Admin Option) and the DBA (with the Admin option) for the ARADMIN user.. Have some more roles been added to 7.5? I do not have the documents handy right now to check so someone could kindly verify this for me? Joe _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARADMIN user Roles for ARSYSTEM on 7.5
Leonard, Thanks! Thats probably the one.. I'll give that a shot.. Joe From: Leonard Neely - FOJ lne...@focusonjobs.com To: arslist@ARSLIST.ORG Sent: Monday, July 13, 2009 12:54:55 PM Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 ** In that case, try looking in ” C:\Documents and Settings\Administrator\Local Settings\Temp\ arsystem_install_log.txt (assuming you are logged into the server as “Administrator”) Leonard From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, July 13, 2009 9:35 AM To: arslist@ARSLIST.ORG Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 ** I should have given more details :-) I would look there but that directory has not yet been created. I want to start reading the install logs the moment the installer kicks up. This is a new install, I'm seeing a couple of points of failures during the install and I wanted to see the 'temp' logs equivalent to those found in the /tmp or the /usr/tmp directory in UNIX during UNIX installs. Joe From:Leonard Neely - FOJ lne...@focusonjobs.com To: arslist@ARSLIST.ORG Sent: Monday, July 13, 2009 12:17:22 PM Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 ** Hi Joe, Try looking in “InstallDrive:\Program Files\BMC Software\ARSystem\Logs” HTH Leonard Neely From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, July 13, 2009 9:04 AM To: arslist@ARSLIST.ORG Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 ** Jarl, Its the 3rd and 4th step that I was missing, thanks for pointing me to that. I got an email from Remedy Support regarding the same at about the same time I heard from you, so thanks for the info anyways. Another somewhat related questions to those more familiar with setting up ARS on a Windows server. At the time of running the install, any idea where the ar_install.log file gets created? I did look in the C:\Windows\Temp directory, but didn't see any familiar files there.. Joe From:Jarl Grøneng jarl.gron...@gmail.com To: arslist@ARSLIST.ORG Sent: Friday, July 10, 2009 3:05:22 PM Subject: Re: ARADMIN user Roles for ARSYSTEM on 7.5 From the install guide; (oracle) To use a previously created tablespace in AR System 1 In an SQL*Plus window, create the tablespace. For example: create tablespace arsys datafile 'c:\qa\data\QATST\data\arsys.dbf' size 500M reuse; 2 Create a user. For example: create user aradmin identified by AR#Admin# default tablespace arsys temporary tablespace temp quota unlimited on arsys; 3 Create a role for the user you created. For example: create role ARole_arsys not identified; 4 Set the privileges for the role. For example: grant alter session, create cluster, create database link, create sequence, create session, create synonym, create table, create view, create procedure, create trigger, query rewrite to ARole_arsys; 5 Grant the role to the user. For example: grant ARole_arsys to aradmin; 2009/7/10 Joe DeSouza joe_rem...@yahoo.com: To the best of my knowledge the previous versions it was enough to have full CONNECT (with the Admin Option) and the DBA (with the Admin option) for the ARADMIN user.. Have some more roles been added to 7.5? I do not have the documents handy right now to check so someone could kindly verify this for me? Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARADMIN user Roles for ARSYSTEM on 7.5
From the install guide; (oracle) To use a previously created tablespace in AR System 1 In an SQL*Plus window, create the tablespace. For example: create tablespace arsys datafile 'c:\qa\data\QATST\data\arsys.dbf' size 500M reuse; 2 Create a user. For example: create user aradmin identified by AR#Admin# default tablespace arsys temporary tablespace temp quota unlimited on arsys; 3 Create a role for the user you created. For example: create role ARole_arsys not identified; 4 Set the privileges for the role. For example: grant alter session, create cluster, create database link, create sequence, create session, create synonym, create table, create view, create procedure, create trigger, query rewrite to ARole_arsys; 5 Grant the role to the user. For example: grant ARole_arsys to aradmin; 2009/7/10 Joe DeSouza joe_rem...@yahoo.com: ** To the best of my knowledge the previous versions it was enough to have full CONNECT (with the Admin Option) and the DBA (with the Admin option) for the ARADMIN user.. Have some more roles been added to 7.5? I do not have the documents handy right now to check so someone could kindly verify this for me? Joe _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are