Siten0308
SSCarpal Tunnel
Points: 4404
More actions
March 24, 2020 at 7:32 pm
#3736747
Hello,
Simple question, can the OPENROWSET if enabled, grant all access to databases only? or can i specify to only for a particular database?
Jo Pattyn
SSC-Dedicated
Points: 32347
March 25, 2020 at 10:03 am
#3736835
I don't think you can limit it to a particular database. Security is handled with linked server login mapping and the destination can also block certain logins
https://docs.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql?view=sql-server-ver15
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply