Re: Granting CREATE ALL TABLES to a user

Time to read a little more and do a little less:

There is no CREATE ALL TABLES right; there is a CREATE ANY TABLE one and that is used to give a user ( who also has resource privs) the right to create tables in any schema...

The table name is composed of two parts: SchemaName.tableName
The schema name is the user who created the table, the table name is the table name...

Read up on
Creating Users
Granting Rights
Basic DBA concepts...

Oracle is not a RDBMS that you can easily 'learn by doing' --- read the online docs,
visit technet.oracle.com and/or get a good book on Oracle Administration ( look for some by Kevin Loney)

"Thomas Løvlie" <thomasl_at_c2i.net> wrote:

>The company I work for has decided to change from Solid DB to Oracle8 so I
>have downloaded Oracle8i Lite to test and learn a little, but already I have
>a couple of questions.
>
>So please help me out here.
>
>The first problem I encountered was when I tried to create some tables. I
>use ODBC to write the SQL (I have also tried using SQL+) but I keep getting
>the error 'table already exists'. I read in a book I bought that the error
>comes when a user is not granted the CREATE ALL TABLES right. But I connect
>to the database using SYSTEM/MANAGER and I thought that user had the rights
>to create tables.
>
>The second problem came when I tried to create a user, First I created a
>user 'Thomas' and I tried to use SQL+ to grant the rights, I wrote 'GRANT
>CREATE ALL TABLES TO THOMAS' but when I pressed ENTER I keep getting a next
>line starting with '2:'. I also tried writing 'EXECUTE' first but nothing
>helps.
>
>So please help me out here.
>
>Thanks in advance
>
>Thomas Løvlie
>thomasl_at_c2i.net
>Delphi Developer for Digitalteknikk AS
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Apr 13 2000 - 00:00:00 CDT