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
Microsoft SQL ServerMicrosoft Legacy OSMicrosoft Development

Avatar of undefined
Last Comment
Guy Hengel [angelIII / a3]

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
arnold

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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?
arnold

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?
Guy Hengel [angelIII / a3]

>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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck