[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

To Create Database files with Read-only access

Priya

3/19/2007 6:15:00 AM

Hi all,

I need to create a new database and not allow the user to delete
the .mdf and .ldf files in the SQL server Data directory. How can I
restrict the user from not deleting the physical files from the
directory programmatically?

Thanks

1 Answer

Uri Dimant

3/19/2007 6:33:00 AM

0

Priya
You or a Network Admin should deny at least 'Modify' permission on the
folder where files located for the users


"Priya" <priyavaithianathan@gmail.com> wrote in message
news:1174284875.229178.270740@b75g2000hsg.googlegroups.com...
> Hi all,
>
> I need to create a new database and not allow the user to delete
> the .mdf and .ldf files in the SQL server Data directory. How can I
> restrict the user from not deleting the physical files from the
> directory programmatically?
>
> Thanks
>