Found it! EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'AD Provider' grant select on corpsysad_allusers to public select * from corpsysad_allusers create view corpsysad_allusers as SELECT name FROM OPENQUERY( ADSI, ' SELECT name FROM ''LDAP://163.232.12.200/CN=Application Users,DC=ppl2kdv''') where ppl2kdv is the root node of my AD (others may include the complete .com.au or whatever, if […]
2003-06-10
yeah, I saw that too. I was just looking for the same inherited right that sa has to execute. Thanks for the thought. John Zacharkan
2003-06-10
You can use user defined role and add members to the role. Whatever permission the role is given will be inherited by members. But every time new objects are added, you need to adjust permission on the Role. In other word permission has to be set explicitly on newly created objects @ role level. MW
2003-06-10
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers