Home » SQL & PL/SQL » SQL & PL/SQL » New user with CREATE SESSION privilege
New user with CREATE SESSION privilege [message #220226] Mon, 19 February 2007 12:08 Go to next message
IT Guru
Messages: 59
Registered: January 2007
Member
Which statement is true concerning a new user that has only been granted the CREATE SESSION privilege?

The user can create a table.
The user can alter their password.
The user can select from tables they have created

I belive he can change his password , for that does not requir any sp. privileges.

[Updated on: Mon, 19 February 2007 12:11]

Report message to a moderator

Re: New user with CREATE SESSION privilege [message #220228 is a reply to message #220226] Mon, 19 February 2007 12:50 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
If you have DBA rights, you should be able to test this yourself.
Re: New user with CREATE SESSION privilege [message #220230 is a reply to message #220228] Mon, 19 February 2007 13:02 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
But if he doesn't have DBA granted, he can't check it.

Logically: if only one answer is true, it must be the second one because user can not select anything from a table (answer 3) if he can not create it (answer 1). In another words,, if he could create it, he would be able to select it -> two correct answers.

And no - with CREATE SESSION, you can not create a table.
Re: New user with CREATE SESSION privilege [message #220269 is a reply to message #220230] Tue, 20 February 2007 00:06 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Littlefoot wrote on Mon, 19 February 2007 20:02
But if he doesn't have DBA granted, he can't check it.

In which case he should download a version of XE or 10g, install it on his local machine and start playing with that!
Previous Topic: How to convert numbers to words (In Rupees format)
Next Topic: help for slecting right options
Goto Forum:
  


Current Time: Sat Dec 03 22:39:34 CST 2016

Total time taken to generate the page: 0.24209 seconds