RE: Privileges for other's table

2002-09-10 Thread Hand, Michael T
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.

Re: Privileges for other's table

2002-09-09 Thread zhu chao
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