Newbie in ver.7 Some basic questions
From: Wong Pui Ming <s11976_at_net2.hkbu.edu.hk>
Date: 1995/07/10
Message-ID: <3tqgo8$vtu_at_ctsc.hkbc.hk>#1/1
5. Default Role setting is ALL, and I grant CONNECT,RESOURCE explicity
Date: 1995/07/10
Message-ID: <3tqgo8$vtu_at_ctsc.hkbc.hk>#1/1
I have been using ver 6 for a long time (the creating users procedure is much simpler). Now I have a system running ver 7.1, I tried to test creating a new user, taking most defaults under the SQL*DBA menu interface for adding a new user. The following are applied to user:
1. Use OS Authen. 2. Default Table Space is SYSTEM, temporary is TEMP 3. Unlimited quotas for both tables 4. Profile uses DEFAULT (and i use the default system setting,i.eRESOURCE_LIMIT=FALSE )
5. Default Role setting is ALL, and I grant CONNECT,RESOURCE explicity
Questions:
1. Are the above adequate for the user to try out the tutorial in
SQLPLUS, SQLFORMS30 ...
2. Now when the user started sqlplus, the following messages come up:
Warning: Product user profile into not loaded
Error in disabling roles in product user profile
(But sqlplus still comes up okay) What do these messages mean, are they harmful ?
-- ___ ___ L_|_ _|_J ( -O> <O- ) ___//\J +-------------------------------------------------+ L/\\___ //-,\ | WONG Pui-ming Email: pm_at_hkbu.edu.hk | /,-\\ || / \\___L System Support Programmer, Computer Centre J___// \ || _ ''/\/ '---J Hong Kong Baptist University L---' \/\'' _ / \ //\\. | 224 Waterloo Road , HONG KONG | .//\\ / \ |_/\'/ || +-------------------------------------------------+ || \'/\_| ' ||_ _|| ' |__) (__|Received on Mon Jul 10 1995 - 00:00:00 CEST