Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

hide sys files from ODBC connection

 
   Database Help (Home) -> Programming RSS
Next:  Error Msg  
Author Message
pelican

External


Since: Jan 17, 2008
Posts: 31



(Msg. 1) Posted: Tue May 18, 2010 8:20 am
Post subject: hide sys files from ODBC connection
Archived from groups: microsoft>public>sqlserver>programming (more info?)

Hi everyone,
I have an ODBC connection in Microsoft Access to download data from a SQL
server. One problem is that the Import Object window will display not just
the databse tables that I want to download, but it also lists all the
Information_Schema tables and the sys tables. I would like to disable the
display of the Information_Schema and sys tables because this ODBC connection
will be used by users that do not need to know the system information on SQL.
The SQL login of this ODBC connection currently is in the "guest" group, and
have a "public" checked under "server roles." I tried to uncheck the "server
roles" but it would not let me. Can anyone let me know how to hide sys files
and information_schema files from the user?
Thanks a lot!

 >> Stay informed about: hide sys files from ODBC connection 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How to hide connection string details - Hi, I have developed a .Net Windows application that has to connect a SQL Server database. Currently i am using the following connection string for connecting this database: server=myserver;database=mydatabase;uid=myuser;pwd=mypassword Unfortunately....

Storing pdf files into IMAGE column using odbc or ado - Hi everyone, I'm new to this group I've tried a ruby and perl group but no one seems to understand how to do this. I have a pdf (coming in through a webapp, i can make a copy of it to disk) and I need to store it into a image column in sqlserver 2005.....

VBS to SQL Connection (Alternate Connection Method) - I have a simple script that I am using to connect to a SQL server, read, process and then write back information. The script works right now, but I am wondering if there is a better way to connect up to the SQL server. Right now I am using..

Connecting to SQL Server thru ODBC System DSN vs ODBC File.. - Currently, I'm using ODBC System DSN to connect to SQL Server 2000/2005. I'm thinking about using ODBC File DSN instead since it does not write to registry which is protected by UAC in Vista. I only know that ODBC File DSN simply means the..

Encrypting in SQL Server 2005 to hide data for sysadmin? - Hi! Would it be possible to use encryption in SQL Server 2005 and make it impossible for the sysadmins (incl. 'sa') to decrypt the data? We thought of certificates protected by a password, but we would then have to pass the password as a parameter to ou...
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]