Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SCHEMA rights Expand / Collapse
Author
Message
Posted Thursday, September 26, 2013 2:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:42 AM
Points: 362, Visits: 440
Hello all,

If a user has no SELECT rights on a schema (it's denied) he can't perform a SELECT statement on a table belonging to that particular schema. Oké, but how is it possible that that same user can perform an export task on a table belonging to that schema?

Any ideas?

Thanks
Post #1498723
Posted Thursday, September 26, 2013 2:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 13,636, Visits: 11,509
You mean with the Export wizard?
Maybe another account is used to run the SSIS package behind the scenes?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1498724
Posted Thursday, September 26, 2013 2:48 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:42 AM
Points: 362, Visits: 440
Yes, inderdeed the export wizard. Is it possible that that wizard uses another user than the user that has logged in?
Post #1498726
Posted Thursday, September 26, 2013 2:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 13,636, Visits: 11,509
jos.haemers (9/26/2013)
Yes, inderdeed the export wizard. Is it possible that that wizard uses another user than the user that has logged in?


According to the documentation, the user should have SELECT permissions.

SQL Server Import and Export Wizard

Strange issue...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1498727
Posted Thursday, September 26, 2013 5:03 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 21, 2014 11:24 AM
Points: 153, Visits: 981
Hi
If a user has no permissions on the tables, he cannot even see them in the wizard.
No way he can export data.
I cannot imagine a bug this big.
Remember, when running the export wizard, one is asked for (new) credentials.
Check again which user was really active when the export was done, and the permissions.
SA or dbo would not get denied anything, but I suspect you'd excluded that.


Andreas

---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
Post #1498764
Posted Thursday, September 26, 2013 5:25 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:42 AM
Points: 362, Visits: 440
Hi Andreas, you're right. We weren't aware of the fact that we used the export wizard with our own credentials.

Thanks!!
Post #1498769
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse