zhu chao,
Thanks for checking this out. I tried it again this morning and it worked
like your example. At first I thought there might be a difference when
creating a view on all rows (*) versus creating the view on a subset (x, y,
z) but under both conditions a view was created successfully.
Ok, I haven't had to deal with privileges much lately but this one had be
stumped for a while, V8.1.7 Tru64.
This is from an account with minimal privileges:
SQL select count(*) from sys.obj$;
select count(*) from sys.obj$
*
ERROR at line 1:
ORA-00942: table or view
Hand, Michael T,
hi, what you tested is not the normal behavior of oracle, neither the document
said like that nor in my database behavior like that.Maybe something is wrong with
your database:)
Look:
SQL conn internal
Connected.
SQL create user t identified by t;
User