OraFAQ Forum: SQL & PL/SQL » DB table creation errors

Home » SQL & PL/SQL » SQL & PL/SQL » DB table creation errors

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB table creation errors [message #1871]

Thu, 06 June 2002 15:58

Reim
Messages: 1
Registered: June 2002

Junior Member

I have just configured 8.1.7 Enterprise on a Win 2000 server and Client on a 2000 workstation. I can create users and grant permissions. When I log on as a user and attempt to create a table, I can't. Any ideas??

Report message to a moderator

Re: DB table creation errors [message #1872 is a reply to message #1871]

Thu, 06 June 2002 16:18

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did you give privileges or roles?
better give roles.
login as dba (sys or system).
create a user (say...guest).
something like this.

SQL> create user guest identified by guest;

User created.

SQL> grant resource,connect to guest;

Grant succeeded.

SQL> connect guest/guest@high9i
Connected.
SQL> create table test ( id number);

Table created.

Report message to a moderator

Previous Topic:	partitioning tables
Next Topic:	Difference between Synonym and View

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 22:43:03 CDT 2024