Default users in Oracle------ Sys and System

[Guest_imported]

Hi,

I am learning SQL on oracle 8i personal ed. After intalling the software and creating a DB, I found that there were two default users namely sys and system. I created a new table in sys but when I tried to drop columns it didnt work. Can any one tell me what are the roles and previlleges of these two default users. I have now created a new user. how do I grant roles nad previleges to my new user. Please help.
Meetu.

 

[goviraja]

Hello, may be by this time you could have solved the problem.
SYS is the user who has most privileges on a database.
Normally, you must create a new user account with users tablespace as default. Grant connect. resource to newuser, then connect as new user and create the table. You must not use SYS or SYSTEM to create tables.

To drop a column you need to have "alter table" privilege.

Definitely your error while dropping a column as sys user is not "insufficient privileges". Means you may have some syntax problems.

Good Luck.
-/Raja