Geeks Talk

Prepare for your Next Interview


Welcome to the Geeks Talk forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

user groups

This is a discussion on user groups within the Oracle forums, part of the Databases category; hi I want to know how to create user's in oracle. When I am trying to create it showing no privielages to create users. I request if anybody could help ...

Go Back   Geeks Talk > Databases > Oracle
Register Blogs FAQ Tag Cloud Calendar Mark Forums Read

Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-24-2007
Junior Member
 
Join Date: Mar 2007
Location: boston
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
srilu.srilatha is on a distinguished road
user groups

hi
I want to know how to create user's in oracle.
When I am trying to create it showing no privielages to create users.
I request if anybody could help me in this matter.
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 05-25-2007
Expert Member
 
Join Date: Jun 2006
Location: India
Posts: 413
Thanks: 15
Thanked 43 Times in 31 Posts
jamesravid will become famous soon enough
Re: user groups

It looks like "Create User" privilege have not granted to your user...A dba user can grant you this privilege.
__________________
Cheers,
:) James:)
Reply With Quote
  #3 (permalink)  
Old 05-25-2007
Expert Member
 
Join Date: Nov 2006
Location: Hyd-IND
Posts: 528
Thanks: 1
Thanked 63 Times in 50 Posts
sutnarcha is on a distinguished road
Re: user groups

The dba has to run a command...

GRANT CREATE ON //database name// TO //ur username//;
__________________
Lack of WILL POWER has caused more failure than
lack of INTELLIGENCE or ABILITY.

-sutnarcha-
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
Run a program as a different user in XP Lokesh M Windows 10 10-28-2007 02:41 PM
Tester is not a dumb user! jainbrijesh Group Discussions 1 06-18-2007 06:35 AM
New User imran.nabi Get Together 5 05-28-2007 01:36 AM
What is the difference between User RD and BRD? sheenajo Test Cases 2 08-15-2006 08:33 AM
Interaction between C and VB User Interface. satya999 C and C++ 0 07-27-2006 05:31 AM


All times are GMT -4. The time now is 03:21 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.1
Copyright © 2009 GeekInterview.com. All Rights Reserved