Home » SQL & PL/SQL » SQL & PL/SQL » how can i grant privilege to new user
how can i grant privilege to new user [message #323256] Tue, 27 May 2008 23:21 Go to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

hi

i login as SYSDBA and create a user by CREATE USER user1 IDENTIFIED BY password;

then to give session create privilege i enter GRANT CREATE SESSION TO user1;

and then enter grant sysdba to user1

now i can connect user1 but when im trying to create table following error occurs:

ORA-01031: insufficient privilege

can any one help me to overcome this?


Thanks in advance
Suman
Re: how can i grant privilege to new user [message #323257 is a reply to message #323256] Tue, 27 May 2008 23:27 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>and then enter grant sysdba to user1
>now i can connect user1 but when im trying to create table following error occurs:
>ORA-01031: insufficient privilege
>can any one help me to overcome this?
You have no privilege to CREATE TABLE.

SQL> GRANT CREATE TABLE TO USER1.
Re: how can i grant privilege to new user [message #323268 is a reply to message #323256] Wed, 28 May 2008 00:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
grant sysdba to user1

I think you don't know what this mean.
The most dangerous privilege you can grant.

Regards
Michel
Re: how can i grant privilege to new user [message #323272 is a reply to message #323257] Wed, 28 May 2008 00:30 Go to previous messageGo to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

thanx its working. but im seeking 1 command by which i can execute maximum DDL,DML,DCL

Re: how can i grant privilege to new user [message #323274 is a reply to message #323272] Wed, 28 May 2008 00:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The basic principle of security is to give the least privileges mandatory to do the job.
It is even a good principle in test database for test user then you learn which privilege you must have for each action you have to execute.

Regards
Michel
Re: how can i grant privilege to new user [message #323371 is a reply to message #323268] Wed, 28 May 2008 05:46 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
To be fair, SYSDBA probably won't let him do as much damage as DBA would.
Previous Topic: OAS - Web page issue
Next Topic: Remove characters from field
Goto Forum:
  


Current Time: Sun Dec 04 00:48:06 CST 2016

Total time taken to generate the page: 0.15652 seconds