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 17 (of 17 total)

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

Johan Bijnens SSC Guru Points: 135373 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/code to get the best help[/url]

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

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

Need a bit of Powershell? How about this

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

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

Ed B

Hall of Fame

Points: 3669

December 19, 2023 at 8:25 am

#4348747

second page

Thom A SSC Guru Points: 99133 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