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"