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.
| Author |
Topic |
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
 Posted - 2008-10-29 : 08:00:58
|
| We converted from 2000 to 2008 but I am having alot of issues with Permissions that were working and now are not. Partiularly stored procidures with multiple tables and temps. (Windows authentification)What is the best way to trace what is being requested,what the server sees as the user (we use alot of groups) what the and what is being denied.JimUsers <> Logic |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-31 : 12:25:13
|
| did you try transfering permissions from sql 2000 db using transfer sql server object task in SSIS?http://msdn.microsoft.com/en-us/library/ms142159.aspx |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-31 : 12:28:19
|
| Here is the one from script library:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111431 |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2008-10-31 : 13:02:11
|
| Most of what I am runnig into is multiple tables within a procidure and for som reason the user does not have the apropriate permisssion for one of the tables.What I am looking for is a way to get a denial log.Example: proc1 needs read access on table1 and table2 but write access on table3. Error log entry.domain1\user1 Failure on Stored procidure proc1 on 12:30AM 10/30/2008 User denied write access on table3.JimUsers <> Logic |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-01 : 02:49:04
|
| is this a one off case or are you getting similar errors for more than one tables? |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2008-11-03 : 07:22:49
|
| Multiple tables and procidures.JimUsers <> Logic |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2008-11-03 : 10:30:54
|
| You can create a trace and capture the User Error Message event. That will show you all errors that are returned to users.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
|
|
|
Permissions