what is the best internal structure for setting up users, and tables?
We are trying to set up a small development (3 developers) environment using Oracle. This is what we have done so far:
1.- Installed Oracle and created a database
2.- Created tablespace and users (3) for that database while signed on using SYS as SYSDBA
Our question is should one of these users have DBA privileges so he can create the tables for the database then grant priviliges to these tables to the other 2 developers? OR should we just continue signing on using SYS as SYSDBA and create the tables??
Knowledge is the function of being.