0
Good morning gentlemen
I created a view and later created a user
CREATE USER pafunsio IDENTIFIED BY "pafunsio";
assigns Grant to connection
GRANT CREATE SESSION TO pafunsio;
and assigns Grant to the view VW_TEST that is in my schema teste
GRANT SELECT ON "teste"."VW_TEST" TO "pafunsio";
but when logging in with the user pafunsio I cannot see the view created
Does anyone have any idea what’s missing ?
"visualize" where ? Sefor in Developer will be in "other users". You can run an sql like "select * from "test"." VW_TEST" ?
– Motta
with the user "SYS" I can access the view without problem
– godoy.alexandre
What’s the problem ? in which program ?
– Motta
i created the view with the user "SYS", created the view and assigns the Grants, but when I log in with the user "pafunsio", and try to make a
select * from VW_TEST, returns the errorORA-00942: table or view does not exist– godoy.alexandre
try select * from SYS.VW_TEST , you should not create user objects in sys or system
– Motta
It worked with select * from test.VW_TEST, Thanks Motta
– godoy.alexandre