Answer / bhaskar

To some extent what you can/should do to restrict direct
access depends on you application and deployment
requirements, and what type of direct access you are trying
to prevent. For instance, if you are sole administrator of
all machines that the app will be deployed on, you may be
able to restrict access by locking down the SA password and
dissallowing access to the DB files via the filesystem.
If, on the other hand, you are not the admin, it will be
pretty much impossible to completely block direct access
against a determined admin. The databases can always be
copied via the filesystem to another machine with a useable
SA account.

Even if you are not the admin of the machine, there are
some things you can do to avoid casual access outside of
the app itself. Here is an article that talks about
securing your connection string:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnnetsec/html/THCMCh14.asp

You can also use an application role for server-side
permissions. See:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_security_89ir.asp

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

How to list all user names in a database?

0 Answers  

---

Why truncate is ddl?

0 Answers  

---

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  

---

What is the default fill factor value?

0 Answers  

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

How to execute multiple stored procedures at one time in sql server?

0 Answers  

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

---

What is the sql server 2000 version number?

0 Answers  

---