Well this is such a great question ... I think anybody wondered once since turning 30 ... But people usually mix 2 different things: one is stop working and do...

SwePeso (11/3/2010)

---

You don't need a tvf here.

declare @pol_cd char(18), @val_date datetime

set @pol_cd = 'xx000000'

set @val_date = '2010/06/30'

...

+1

SOLVED ...

the problem was with the database roles granted

thank you very much

thank you so much silverfox for your precious help!!!

it works now ...

I'll drink a big beer on you this evening

🙂

a large step forward, thanks

the view was created under dbo. I deleted it and recreated it under zs1 and it solves question 1! thanks!!!

for question 2, my aim is to...

Let me summarize the situation.

SQL server

a login zl1 is mapped to the DB dbqa3 with user zu1 default schema zs1

database roles are db_datareader, db_denydatareader, public

DB dbqa3

USERS default schema is zs1

database...

Thank you for your answer Adam. This is what I did, but it doesn't work the way I'd like to. I may have overlooked something, but what 🙂

Thank you bitbucket for your answer.

Unfortunatly the article relates to sql server 2000 and excludes the schemas of sql 2005.

It is however helpful on some issues ... thank you

Added

EXEC sp_addrolemember 'db_reader', 'zu1'

to my code, but it doesn't help

Hi,

I'll really appreciate if someone could help me on this one.

My aim is to grant reader rights to one specific user to only one view.

So I wrote and ran following...

What if I create a user U1,

then I create a schema S1 to which I attach the user U1 with "deny all" permissions,

then, in the Properties of the specific view...

ok, thanks ...

No, not yet, but I propose to close this thread as it's not accute anymore ... for the moment

how can I close it?

Hi,

I might have found a work around ... Is there a way to create a SP with a system stored procedure?

Thx

EDIT: got it : sp_executesql but work around doesn't work...