Home » RDBMS Server » Server Administration » Create_table privilege.
Create_table privilege. [message #54136] Thu, 31 October 2002 07:13 Go to next message
Natalia
Messages: 4
Registered: September 2000
Junior Member
I created an user with create_table privilege. Now, after the user create a table he canīt see it. Whatīs wrong?

Report message to a moderator

Re: Create_table privilege. [message #54141 is a reply to message #54136] Thu, 31 October 2002 11:02 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Give him the select privilege.. :))

Report message to a moderator

Re: Create_table privilege. [message #54143 is a reply to message #54136] Thu, 31 October 2002 11:47 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
By default user has all rights to its own objects. No need to grant SELECT on own objects.

Did the table really exists? What is the output of :
SQL>desc table_name

Do you have any public synonyms for the same table name? Does the user have rights to this public synonym? Most probably, the table was to created. Check this !

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: ORA-24327
Next Topic: Net8 Assistant not opening
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 27 13:16:47 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.