| scott /tiger cant see system tables/cant create another user [message #314851] |
Fri, 18 April 2008 01:03  |
oracle_me
Messages: 45
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 #314866 is a reply to message #314851 ] |
Fri, 18 April 2008 01:32  |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
How is this a SQL expert question?
It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Read them, follow them.
As you are an expert, I don't answer the question because you obviously already knows it.
Regards
Michel
[Updated on: Fri, 18 April 2008 01:32]
|
|
|
| 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: 5640
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
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.
|
|
|
]
Members
Search
Help
Register
Login
Home
