Link to home
Start Free TrialLog in
Avatar of fijiboy
fijiboy

asked on

SQL Access Interface

Hi there,

I have a scenario in which a non-IT department staff is using SQL syntax queries to retrieve data from a critical application with Sybase.

While provides the information that the staff requires for their job it also poses a risk for us in IT as clearly scq scripts are being run directly into the database.

As the IT personnel in charge i would like some assistance or resource reference linkks to design a GUI interface where possibly with Visual Studio which is a more safer and best practice method.

thank you
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fijiboy
fijiboy

ASKER

I have the queries already and while the staff concerned gets the correct information they require I do not agree with the method of extracting the data from the database, what if a DROP or DELETE command was accident entered into the script?
 
Why would i need to link the Sybase DB to SQL server?
From your zone choice I jumped to the conclusion that the sybase setup is .....

Is a web base interface an option?
Think it is simpler than setting up an app that would the. Need to be distributed.
http://www.dofactory.com/Connect/Connect.aspx

You could administer rights
http://manuals.sybase.com/onlinebooks/group-asarc/srv10024/sag/@Generic__BookTextView/16131;pt=17256
Is data being added as well?
>I have the queries already and while the staff concerned gets the correct information they require

if you have the queries, and it's all day/week/month the same queries, you should set up reports using those SQL.

>  ... what if a DROP or DELETE command was accident entered into the script?
make sure the login they are using are only granted SELECT permissions (to the tables/views needed)
that way, the DB will refuse and DROP/DELETE/UPDATE whatever attempt built-in