Row Level Security Updates

Question

Post reply

Row Level Security Updates

Steve Jones - SSC Editor

SSC Guru

Points: 736479
More actions
March 26, 2016 at 5:44 pm

#73661

Comments posted to this topic are about the item Row Level Security Updates

Viewing 12 posts - 1 through 11 (of 11 total)

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Shouldn't the policy send the username column like this?

CREATE SECURITY POLICY rls_CustomerFilter

ADD FILTER PREDICATE dbo.rls_customer_check(username)

ON dbo.CustomerAccessList;

GO

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

timwell SSCertifiable Points: 5315 More actions · Answer 2

Luis Cazares (3/28/2016)
Shouldn't the policy send the username column like this?
CREATE SECURITY POLICY rls_CustomerFilter
ADD FILTER PREDICATE dbo.rls_customer_check(username)
ON dbo.CustomerAccessList;
GO

I had a similar question. I guessed that it would get an error because of the type mismatch...

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 3

yes, sorry. Typo corrected. That's what I get for trying to type code in here instead of copy/paste.

TomThomson SSC Guru Points: 104773 More actions · Answer 4

Nice question,

It's very like the question 11 days go. Are you trying to din this into us by repetition? (If so, good on you!)

Tom

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 5

TomThomson (3/28/2016)
Nice question,
It's very like the question 11 days go. Are you trying to din this into us by repetition? (If so, good on you!)

More just trying to get people aware of the limits and functionality. Look for a few more across the next couple months.

George Vobr SSChampion Points: 10009 More actions · Answer 6

The question is imprecisely worded. In the question does not mention that the bsmith user has rights to insert/update the table.

Last time it was there.

HappyGeek SSCoach Points: 18729 More actions · Answer 7

George Vobr (3/28/2016)
The question is imprecisely worded. In the question does not mention that the bsmith user has rights to insert/update the table.
Last time it was there.

Started with the correct answer then changed my mind for the same reason hmm.

...

Ed Wagner SSC Guru Points: 287026 More actions · Answer 8

Steve Jones - SSC Editor (3/28/2016)
TomThomson (3/28/2016)
Nice question,
It's very like the question 11 days go. Are you trying to din this into us by repetition? (If so, good on you!)
More just trying to get people aware of the limits and functionality. Look for a few more across the next couple months.

One thing I really appreciate about the QOTD is that it exposes people to things they haven't used before, like this question. Learning something new is a good way to start the day, so thank you.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 9

Steve Jones - SSC Editor (3/28/2016)
yes, sorry. Typo corrected. That's what I get for trying to type code in here instead of copy/paste.

Copy/paste can be just as dangerous. I've seen so many pieces of code where it was not modified correctly after the copy/paste, especially when it comes to correcting the alias names.

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 10

Very interesting QotD.

It works only on SQL Server 2016, even though it's "documented" for SQL 2014.

In documentation for version 2014 https://msdn.microsoft.com/en-us/library/dn765131(v=sql.120).aspx

it says Row-Level Security is now available in SQL Server 2016. which is wrong.

Igor Micev,My blog: www.igormicev.com

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 11

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP