Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps you will take, if you are tasked with
securing an SQL Server?
- 1 Answers
- 5279 Views
- STC, I also Faced
- E-Mail Answers
Answer Posted / sandeep
Again this is another open ended question. Here are some
things you could talk about: Preferring NT authentication,
using server, databse and application roles to control
access to the data, securing the physical database files
using NTFS permissions, using an unguessable SA password,
restricting physical access to the SQL Server, renaming the
Administrator account on the SQL Server computer, disabling
the Guest account, enabling auditing, using multiprotocol
encryption, setting up SSL, setting up firewalls, isolating
SQL Server from the web server etc.
Read the white paper on SQL Server security from Microsoft
website. Also check out My SQL Server security best practices
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is the default fill factor value? : sql server DBA
What happens on checkpoint? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How do you trace the traffic hitting a sql server? : sql server DBA
what is logical system in sap basis
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what are the benefits of flashback feature?
What are the different ways you can create databases in sql server? : sql server DBA
What is transparent data encryption? : sql server DBA
