Xref: alice comp.databases.oracle.server:35787
Path: alice!news-feed.fnsi.net!news.new-york.net!woodstock.news.demon.net!demon!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail
From: Sybrand Bakker <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: create session?
Date: Sat, 12 Dec 1998 07:27:27 +0100
Message-ID: <36720CCE.5F75B418@sybrandb.demon.nl>
References: <74sj0p$c84$1@netnews.upenn.edu>
X-Trace: news.demon.nl 913443992 spot:9326 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@demon.net
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en,ja
MIME-Version: 1.0
To: Manu Kambhampati <manuk@gradin.cis.upenn.edu>
Content-Type: multipart/mixed;
 boundary="------------436EAB9DB65082F347EE95D1"
Lines: 47
--------------436EAB9DB65082F347EE95D1
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

grant create session to r2do2;

Hth,

Sybrand Bakker, Oracle DBA

Manu Kambhampati wrote:

> I just installed oracle 7.3.2.1 server on solaris, created a database
> using svrmgrl and created a user using sqlplus. I get the following
> when logging on as the user on sqlplus:
> Help!
> How do I grant CREATE SESSION privileges to users? I created the user
> ------
> SQL*Plus: Release 3.3.2.0.0 - Production on Fri Dec 11 20:57:53 1998
>
> Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.
>
> Enter user-name: r2do2
> Enter password:
> ERROR: ORA-01045: user R2DO2 lacks CREATE SESSION privilege; logon denied
> --

--------------436EAB9DB65082F347EE95D1
Content-Type: text/x-vcard; charset=us-ascii;
 name="postbus.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Sybrand Bakker
Content-Disposition: attachment;
 filename="postbus.vcf"

begin:vcard 
n:Bakker;Sybrand
x-mozilla-html:FALSE
version:2.1
email;internet:postbus@sybrandb.demon.nl
x-mozilla-cpt:;0
fn:Sybrand Bakker
end:vcard

--------------436EAB9DB65082F347EE95D1--