2 Replies - 5032 Views - Last Post: 09 April 2013 - 03:13 AM

#1 dok300  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 16
  • Joined: 27-October 12

New user in Oracle with priviledges

Posted 08 April 2013 - 09:50 AM

I am trying to create a newuser in oralce. The user is to be given the grant, insert, update and delete privileges on the employee table.

SET TRANSACTION newuser;

CREATE USER newuser IDENTIFIED BY password;

GRANT DELETE, INSERT, UPDATE, SELECT ON employee TO newuser;

commit;

I don't have the privileges to create a new user. I would like to know how i can become a super-user in order to create a new user, but i have to login in as my ordinary username to access the tables. The mysql command line client is not functioning.

Any other way to create a new user??

Is This A Good Question/Topic? 0
  • +

Replies To: New user in Oracle with priviledges

#2 dok300  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 16
  • Joined: 27-October 12

Re: New user in Oracle with priviledges

Posted 08 April 2013 - 09:58 AM

posted this in php meant to be in databases. Unable to delete but will repost in the database section. Apologies
Was This Post Helpful? 0
  • +
  • -

#3 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 6081
  • View blog
  • Posts: 23,557
  • Joined: 23-August 08

Re: New user in Oracle with priviledges

Posted 09 April 2013 - 03:13 AM

Moved to Oracle forum
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1