Apologies if this is the wrong subject area!!
Not sure if i'm having one of those days or missed something.
I've just noticed that i have a data server connection to my data warehouse that has an anonymous owner and appears to have all tables and views that are referenced by the published packages!
Now i know, that i haven't created this and no other user has the capability enabled to do this. The only thing i can think is that its been created by the server when I've kicked off the package enrichment tasks?
Does anyone know if this is correct?
The permissions on the data server also replicate and appear to share the permissions to the database connection, i know this as i was a little shocked when i realised that all users had the ability to use the data server to view the data warehouse tables when i hadn't given them direct permission myself.
Again, does anyone know if this is intended behaviour by the product.