Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to disable Export for Db_Datareader Users?

Author  Topic 

irevanescence
Starting Member

1 Post

Posted - 2012-02-07 : 02:12:35
Dear Friends.
I face with problem in my company.
our managers want me to disable Exporting data in SQL 2005 for Readers users.
i checked and i didn't find any option.
any body have solution for this.
please help me .

Regards
Vahid

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-07 : 03:54:43
If they have access to read the data, they have access to read the data (and disabling export would just mean they run a query and copy the results to excel or the like)

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -