3 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
HI mmasseth,
Could there be a conflict in view owner and table owner, or in the view owners privilege to select from the table that was introduced when you changed the table ownership?
-Kurt
répondu il y a 4 ans
0
@klarson, interesting. Changing the view owner to be the same as the the table ended up working.
I guess when querying a view, permissions are a function of the creator, not the invoker ?
répondu il y a 4 ans
0
Hi mmasseth,
I believe the privileges of the creator apply to what the view needs to execute the defining query and privileges of the invoker determine if the view can be used.
Glad it worked out for you.
-Kurt
répondu il y a 4 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 2 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans