"create session"

but you wont be able to do much else

Better suggestion is
"connect", and depending on how much you would like your user to do maybe
also "resource".

Be careful though, this combination allows user too create tables and
indexes in any tablespace on your database. Not usually desireable.

So much depends on your requirements. You might be running an application
which you want the user to access. For that you will need to grant select,
update, insert delete on application objects as appropriate, probably via a
role or two.

At the top end of the scale, you might assign "dba", but I doubt it!

The combinations are mindblowing!

-----Original Message-----
From: Ravi Kumar
[mailto:oracledba-ezmlmshield-x54081675.[Email address protected]
Sent: 30 October 2007 13:38
To: LazyDBA Discussion
Subject: please answer the following question?( Oracle 9i)



Hi Experts



Could you please answer the following question?( Oracle 9i)





When creating a user, what permissions must you grant to allow them to
connect to the database?





Thanks

Ravi



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page