Home » SQL & PL/SQL » SQL & PL/SQL » create user
create user [message #263833] Fri, 31 August 2007 02:40 Go to next message
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 #263840 is a reply to message #263833] Fri, 31 August 2007 02:56 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What is it you are trying to do?
Do you know SQL??
Re: create user [message #263841 is a reply to message #263833] Fri, 31 August 2007 02:57 Go to previous message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How did you create those users? Did you say
SQL> user ara password budgerigar
or did you say
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;
Previous Topic: Need syntax for indexes
Next Topic: Problem with stored procedures
Goto Forum:
  


Current Time: Mon Dec 05 19:32:18 CST 2016

Total time taken to generate the page: 0.06432 seconds