Selecting from a view, base table has a DENY on a column

Question

Selecting from a view, base table has a DENY on a column

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135615 More actions · Answer 1

Since you cannot share the full DDL, can you strip it down to key, onemorecolumn, the denied column and see if the problem also manifests itself in that situation.

Maybe then post the DDL if the stripped tables involved and stripped view ?

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data and code to get the best help

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Who am I ? Sometimes this is me but most of the time this is me

Ed B Hall of Fame Points: 3690 More actions · Answer 2

Ed B

Hall of Fame

Points: 3690

December 19, 2023 at 8:25 am

#4348747

second page

Thom A SSC Guru Points: 99143 More actions · Answer 3

Are these nested views, by any chance?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk