| scott /tiger cant see system tables/cant create another user [message #314851] |
Fri, 18 April 2008 01:03  |
oracle_me
Messages: 59
Registered: March 2008
|
Member |
|
|
Hi ,
Currently I am using schema scott/tiger to work in my local database.
I wanted to create another schema after having logged into scott.
However it says does not have permissions.
Also using scott I am not able to view any system tables/session info /v$ views etc
Can you please tell me how to empower the user scott so that I can create another user in my local db or what best is the alternate solution.
|
|
|
|
|
|
| Re: scott /tiger cant see system tables/cant create another user [message #314867 is a reply to message #314851] |
Fri, 18 April 2008 01:33  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Check the OraFAQ Forum Guide; in there you'll find links to useful sites. One of them is Oracle documentation - visit the site and search for CREATE USER SQL statement. It will show you which privileges are necessary for a user to be able to create another user.
Furthermore, in order to view system views, user has to be granted required privileges. Which ones? See in the documentation (search for V$ VIEWS).
Finally, "creating users", "privileges", "grants" and "roles" do not belong to SQL Experts forum as they don't require advanced SQL knowledge; these are "security" terms.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
