General information
Category:
Conferences & events
>Since you don't use a mapped drive to connect to SQL Server, how would anyone other than the DBA or Network administration have any idea where the SQL Server files are located?
>
So we are talking about security by obscurity? All networks are so secure that no one can hack into them, huh? Additionally, I have seen network admin guys accidently or purposefully delete, rename or move files or change access rights without checking the consequences to users or applications that may have been setup previously causing downtime for users or applications.
>>Also, if anyone has MS Access or Excel and knows a userid and password for accessing the database, they can make a connection and still wreck havoc in the database even with SQL server if they are intent to do so.
>
>And they have a user ID and password with DB write rights why? I have no problem with people having UserIDs and P/Ws with READ access to the data with Excel and Access but they won't have update/delete level rights.
>
My applications use a userid and password that does have read/update/delete rights to the database. I would guess that knowing these, a disgruntled user could access the database via excel or access and cause problems.
>>Obviously, it is because I have Admin rights and know the userid and password for the database and where SQL server stores its files, but my point is that it is not impossible to delete or trash any database,
>
>True...
>
>>Just my 2 cents. I think VFP is a great tool for most any data intensive application using SQL server, VFP tables or other database servers.
>
>We agree here. < s >
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only