| create user [message #263833] |
Fri, 31 August 2007 02:40  |
ara.oracle
Messages: 142
Registered: August 2007
|
Senior Member |
|
|
i had created some users,when i try to list the users i get the following errors.
how to view the list of users who has listed priveliges?
SQL> vSpwfile_users
SP2-0734: unknown command beginning "vSpwfile_u..." - rest of line ignored.
SQL> v$pwfile_users view
SP2-0734: unknown command beginning "v$pwfile_u..." - rest of line ignored.
SQL> V$PWFILE_USERS
SP2-0734: unknown command beginning "V$PWFILE_U..." - rest of line ignored.
SQL> SQL> vSpwfile_users
SP2-0734: unknown command beginning "SQL> vSpwf..." - rest of line ignored.
|
|
|
|
|
|
| Re: create user [message #263841 is a reply to message #263833] |
Fri, 31 August 2007 02:57  |
 |
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
How did you create those users? Did you saySQL> user ara password budgerigar SQL> CREATE USER ara IDENTIFIED BY budgerigar;
There's that funny thing called syntax, and you'll have to keep to some rules if you want to communicate with Oracle database. To obtain information from it, use SELECT statement, not only object name.SQL> SELECT * FROM v$pwfile_users; |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
