Home » RDBMS Server » Server Administration » How to let an user could create table?
How to let an user could create table? [message #134957] Mon, 29 August 2005 03:44 Go to next message
rushing
Messages: 135
Registered: January 2004
Location: Beijing,China
Senior Member
I create a user in Oracle, and want he could create a table, but do not want he is a DBA.
I give him the system role create table , but still could not create table.
How and why?
Thanks!

Report message to a moderator

Re: How to let an user could create table? [message #134961 is a reply to message #134957] Mon, 29 August 2005 03:55 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Run this command and grant these roles to the user. "Username" is the name of the new user.

SQL>Grant Connect,Resource to Username;


Now the user is not a DBA but it can do all other activites.

regards,
tarun

Report message to a moderator

Previous Topic: Test Data generator for oracle?
Next Topic: Urgent -Failed to open database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 04 00:39:52 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.