hiding tables in ms sql
-
good day to everyone. i just want to know how to hide tables in ms sql using c# codes. because, i want to hide the tables so that no one will be able to edit or even delete the tables i've created.thank you very much in advance...
-
good day to everyone. i just want to know how to hide tables in ms sql using c# codes. because, i want to hide the tables so that no one will be able to edit or even delete the tables i've created.thank you very much in advance...
accessing a database can be restricted using usernames and passwords. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
-
accessing a database can be restricted using usernames and passwords. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
thanks for the reply...but is there a way to hide the tables just for add-up securty?thanks again...
-
thanks for the reply...but is there a way to hide the tables just for add-up securty?thanks again...
I don't think so, and I don't see a need. Create your app with the functionality you want, and no more; give it a connection string that provides access to the database; and store that connectionstring in a settings file, outside the app, but encrypted, so the world can't use it, only your app can. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
-
I don't think so, and I don't see a need. Create your app with the functionality you want, and no more; give it a connection string that provides access to the database; and store that connectionstring in a settings file, outside the app, but encrypted, so the world can't use it, only your app can. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
thank you again for the reply...i'm developing a web service which accessed the registry to get some info about some app...i want to save that info to a file or database which the other users won't be able to edit nor delete anything on it or the file itself...can you give me some options for a more secured way...thanks a bunch...:)
modified on Monday, April 5, 2010 1:31 AM
-
thank you again for the reply...i'm developing a web service which accessed the registry to get some info about some app...i want to save that info to a file or database which the other users won't be able to edit nor delete anything on it or the file itself...can you give me some options for a more secured way...thanks a bunch...:)
modified on Monday, April 5, 2010 1:31 AM
Assuming your Web Service runs in IIS, give the user account executing the web service AppPool permissions to access the database table. Do non give these permission to any other user account (excpet administrative account). Doing so the access to the table will be possible only through your Web Service.