Re: newbie start from scratch

Not sure I understand what you're asking. Are you trying to connect internal and its asking for a password. If so, try connecting as system with the password manager as sysdba. If your installation is like mine, the first thing you'll have to do is put your rollback segments online. Only my system rollback segment was online when I first started up my database. You can't do any work without user rollback segments.

There is a usr tablespace created by default, so you don't have to create tablespaces unless you want to. One thing to consider when you start creating tables is that one user owns every table. So if you log in as Tom and create your tables, then Tom must grant access to other users. If Tom leaves the company his account still owns the tables. I think its a good idea to creat meta-users to own the tables... accounts like Accounting, Engineering, etc. Then from the meta-user accounts grant priviledges to groups instead of individuals. Then all you have to do is maintain groups.

Randall Received on Wed Sep 23 1998 - 09:45:15 CDT