To find existing user tables and views, query the ALL_TABLES and ALL_VIEWS data dictionary views. Certain privileges may be required to access the table. If an application returned this message, then ...

This works if I login to the db as nshepherd and use the statement with no "" around the username, it not correct oracle syntax to put "" around username in the alter user command. ALTER USER ...