OK, we have a couple of MS SQL 2000 servers running in a Win2k AD domain.
Both machines are using mixed mode security, the issue appears to be this.
If I go into AD and change a groups name that has been granted access to
the SQL server, it doesn't seem to pick up on the name change.
I also can't add the new name to the SQL server, because of a conflict of a
SID.
So how do I get the MS SQL server to refresh the names of the native NT
groups that have been granted access, then have the names changed ??I think you need to drop the old name and add the new one. Why are you doing this? Experimenting?|||Its not uncommon to have a native AD Security group renamed to match
a changed "department" name lets say.
SQL 2000 doesn't seem to see the name change in AD, where is this info stored in
the SQL server ?? is there a SP to refresh the cache or this table ?|||I'd say changing a department name should result in a change of an OU, not a group. But that's just me.
Showing posts with label security. Show all posts
Showing posts with label security. Show all posts
Friday, March 9, 2012
Wednesday, March 7, 2012
quick question
I have a couple of really quick questions...
How many parameter are allowed for a stored procedure?
and I'm trying to figure out what security level witll set an @.@.error variable to 0.
and lastly, How many log files can be in a filegreoup?
ThanksHow many parameter are allowed for a stored procedure?
1024
and I'm trying to figure out what security level witll set an @.@.error variable to 0.
?? @.@.error return value is cleared before every statement and is a system function not a variable.
How many log files can be in a filegreoup?
0
How many parameter are allowed for a stored procedure?
and I'm trying to figure out what security level witll set an @.@.error variable to 0.
and lastly, How many log files can be in a filegreoup?
ThanksHow many parameter are allowed for a stored procedure?
1024
and I'm trying to figure out what security level witll set an @.@.error variable to 0.
?? @.@.error return value is cleared before every statement and is a system function not a variable.
How many log files can be in a filegreoup?
0
Quick custom security question
I am trying to implement some type of security based on the user, the
report, and what parameters the are supplying.
So lets say that I have a report called "Salary Report" that shows
employees salary and bonus data. The people who can run the report
with Department = 1 are not allowed to run the report as Department = 2.
Previously I believe the answer was to use the "UserId" in my reports,
which would be populated with the current users Username, but we
already have a very complex system for determining peoples rights to
different things on our intranet site.
People can delegate rights to others, people get rights based on their
project assignments, people get rights based on their position in the
company, people get rights based on who they report to, and who reports
to them, and on and on.
So all I need to know to validate is username (or userID), what report
they are running, and what parameters they are supplying.
Is there any way to do this?Would a query based parameter work for you where you use a stored procedure
to return a list of valid parameters that they can use for that report based
on who they are and what rights they have inherrited?
Steve MunLeeuw
"cmay" <cmay@.walshgroup.com> wrote in message
news:1161293948.030847.304270@.m73g2000cwd.googlegroups.com...
>I am trying to implement some type of security based on the user, the
> report, and what parameters the are supplying.
> So lets say that I have a report called "Salary Report" that shows
> employees salary and bonus data. The people who can run the report
> with Department = 1 are not allowed to run the report as Department => 2.
> Previously I believe the answer was to use the "UserId" in my reports,
> which would be populated with the current users Username, but we
> already have a very complex system for determining peoples rights to
> different things on our intranet site.
> People can delegate rights to others, people get rights based on their
> project assignments, people get rights based on their position in the
> company, people get rights based on who they report to, and who reports
> to them, and on and on.
> So all I need to know to validate is username (or userID), what report
> they are running, and what parameters they are supplying.
> Is there any way to do this?
>
report, and what parameters the are supplying.
So lets say that I have a report called "Salary Report" that shows
employees salary and bonus data. The people who can run the report
with Department = 1 are not allowed to run the report as Department = 2.
Previously I believe the answer was to use the "UserId" in my reports,
which would be populated with the current users Username, but we
already have a very complex system for determining peoples rights to
different things on our intranet site.
People can delegate rights to others, people get rights based on their
project assignments, people get rights based on their position in the
company, people get rights based on who they report to, and who reports
to them, and on and on.
So all I need to know to validate is username (or userID), what report
they are running, and what parameters they are supplying.
Is there any way to do this?Would a query based parameter work for you where you use a stored procedure
to return a list of valid parameters that they can use for that report based
on who they are and what rights they have inherrited?
Steve MunLeeuw
"cmay" <cmay@.walshgroup.com> wrote in message
news:1161293948.030847.304270@.m73g2000cwd.googlegroups.com...
>I am trying to implement some type of security based on the user, the
> report, and what parameters the are supplying.
> So lets say that I have a report called "Salary Report" that shows
> employees salary and bonus data. The people who can run the report
> with Department = 1 are not allowed to run the report as Department => 2.
> Previously I believe the answer was to use the "UserId" in my reports,
> which would be populated with the current users Username, but we
> already have a very complex system for determining peoples rights to
> different things on our intranet site.
> People can delegate rights to others, people get rights based on their
> project assignments, people get rights based on their position in the
> company, people get rights based on who they report to, and who reports
> to them, and on and on.
> So all I need to know to validate is username (or userID), what report
> they are running, and what parameters they are supplying.
> Is there any way to do this?
>
Subscribe to:
Posts (Atom)