UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Make Linked SQL Server Table Read Only, SQL Server 2012    
 
   
MadPiet
post Jan 16 2018, 01:31 AM
Post#21



Posts: 2,314
Joined: 27-February 09



Maybe if the SQL Admins granted read-only access to a bunch of tables, and maybe created a schema for him where he could create tables? Then he can query against the read-only tables (because he's explicitly denied UPDATE and DELETE against them or the entire other schema?)
Go to the top of the page
 
2 Pages V < 1 2


Custom Search
RSSSearch   Top   Lo-Fi    19th January 2018 - 10:33 PM