| Author |
Message |
Michael Broschat
Guest
|
Posted:
Mon Dec 27, 2004 8:35 pm Post subject:
Duplicating permissions for a different domain |
|
|
Our network (which includes an STS server) is changing domains. We have
decided to duplicate project users (within the SQL Server database), changing
their domain designation to the new one (and thereby leaving the old
identity, too).
I can do this, but I can't see how to assign any permissions at all. In
other words, if OldDomain\Ralph gets a new identity as NewDomain\Ralph, how
can I programmatically give him the same permissions as OldDomain\Ralph has?
I see how project data is stored in the SQL Server database but cannot find
any reference to the various permissions levels.
Thanks in advance... |
|
| Back to top |
|
 |
Mike Walsh
Guest
|
Posted:
Mon Dec 27, 2004 8:49 pm Post subject:
Re: Duplicating permissions for a different domain |
|
|
Can you please just confirm that your use of "project" does not have
anything to do with Project Server and that you are using STS v 1.0 which
came out in 2001.
Mike Walsh, Helsinki, Finland
STS FAQ at http://www.collutions.com/Lists/FAQ
WSS FAQ at http://wss.collutions.com
Please reply to the newsgroup
"Michael Broschat" <MichaelBroschat@discussions.microsoft.com> wrote in
message news:E373C876-5C48-4229-95F8-46F61857FB0C@microsoft.com...
| Quote: | Our network (which includes an STS server) is changing domains. We have
decided to duplicate project users (within the SQL Server database),
changing
their domain designation to the new one (and thereby leaving the old
identity, too).
I can do this, but I can't see how to assign any permissions at all. In
other words, if OldDomain\Ralph gets a new identity as NewDomain\Ralph,
how
can I programmatically give him the same permissions as OldDomain\Ralph
has?
I see how project data is stored in the SQL Server database but cannot
find
any reference to the various permissions levels.
Thanks in advance... |
|
|
| Back to top |
|
 |
Michael Broschat
Guest
|
Posted:
Mon Dec 27, 2004 9:09 pm Post subject:
Re: Duplicating permissions for a different domain |
|
|
That is correct. This "project" has absolutely nothing to do with Project and
is entirely within the scope of SharePoint Team Services (ie, the old one),
to which we've applied SP3, by the way.
"Mike Walsh" wrote:
| Quote: | Can you please just confirm that your use of "project" does not have
anything to do with Project Server and that you are using STS v 1.0 which
came out in 2001.
Mike Walsh, Helsinki, Finland
STS FAQ at http://www.collutions.com/Lists/FAQ
WSS FAQ at http://wss.collutions.com
Please reply to the newsgroup
"Michael Broschat" <MichaelBroschat@discussions.microsoft.com> wrote in
message news:E373C876-5C48-4229-95F8-46F61857FB0C@microsoft.com...
Our network (which includes an STS server) is changing domains. We have
decided to duplicate project users (within the SQL Server database),
changing
their domain designation to the new one (and thereby leaving the old
identity, too).
I can do this, but I can't see how to assign any permissions at all. In
other words, if OldDomain\Ralph gets a new identity as NewDomain\Ralph,
how
can I programmatically give him the same permissions as OldDomain\Ralph
has?
I see how project data is stored in the SQL Server database but cannot
find
any reference to the various permissions levels.
Thanks in advance...
|
|
|
| Back to top |
|
 |
Mike Walsh
Guest
|
Posted:
Mon Dec 27, 2004 9:40 pm Post subject:
Re: Duplicating permissions for a different domain |
|
|
I wouldn't advise making amendments to the database directly and given that
I can't think how to do what you want programmatically, I would personally
just bite the bullet and
a) print out the users assigned to each different authentication part of the
site (thus getting name and permissions)
and
b) add the permissions by hand
But then people have complained before that they want a programming solution
even if it takes longer in total (including investigating how to do it) ...
Mike Walsh, Helsinki, Finland
"Michael Broschat" <MichaelBroschat@discussions.microsoft.com> wrote in
message news:7289E5C0-2AF5-4FD8-AD5D-C2502AEEA636@microsoft.com...
| Quote: | That is correct. This "project" has absolutely nothing to do with Project
and
is entirely within the scope of SharePoint Team Services (ie, the old
one),
to which we've applied SP3, by the way.
"Mike Walsh" wrote:
Can you please just confirm that your use of "project" does not have
anything to do with Project Server and that you are using STS v 1.0 which
came out in 2001.
Mike Walsh, Helsinki, Finland
STS FAQ at http://www.collutions.com/Lists/FAQ
WSS FAQ at http://wss.collutions.com
Please reply to the newsgroup
"Michael Broschat" <MichaelBroschat@discussions.microsoft.com> wrote in
message news:E373C876-5C48-4229-95F8-46F61857FB0C@microsoft.com...
Our network (which includes an STS server) is changing domains. We have
decided to duplicate project users (within the SQL Server database),
changing
their domain designation to the new one (and thereby leaving the old
identity, too).
I can do this, but I can't see how to assign any permissions at all. In
other words, if OldDomain\Ralph gets a new identity as NewDomain\Ralph,
how
can I programmatically give him the same permissions as OldDomain\Ralph
has?
I see how project data is stored in the SQL Server database but cannot
find
any reference to the various permissions levels.
Thanks in advance...
|
|
|
| Back to top |
|
 |
Michael Broschat
Guest
|
Posted:
Mon Dec 27, 2004 10:03 pm Post subject:
Re: Duplicating permissions for a different domain |
|
|
Thanks, Mike. I was afraid that the manual approach would be the only viable
alternative.
Investigating how to do something (even when it takes longer than doing it
manually) often pays in the future, when you least expect it. Besides, I
maintain that there is no fun in administration, and if you can't think of
some way to make it interesting, you're probably not going to do it much
longer. And certainly not very well...
Broschat
"Mike Walsh" wrote:
| Quote: | I wouldn't advise making amendments to the database directly and given that
I can't think how to do what you want programmatically, I would personally
just bite the bullet and
a) print out the users assigned to each different authentication part of the
site (thus getting name and permissions)
and
b) add the permissions by hand
But then people have complained before that they want a programming solution
even if it takes longer in total (including investigating how to do it) ...
Mike Walsh, Helsinki, Finland
"Michael Broschat" <MichaelBroschat@discussions.microsoft.com> wrote in
message news:7289E5C0-2AF5-4FD8-AD5D-C2502AEEA636@microsoft.com...
That is correct. This "project" has absolutely nothing to do with Project
and
is entirely within the scope of SharePoint Team Services (ie, the old
one),
to which we've applied SP3, by the way.
"Mike Walsh" wrote:
Can you please just confirm that your use of "project" does not have
anything to do with Project Server and that you are using STS v 1.0 which
came out in 2001.
Mike Walsh, Helsinki, Finland
STS FAQ at http://www.collutions.com/Lists/FAQ
WSS FAQ at http://wss.collutions.com
Please reply to the newsgroup
"Michael Broschat" <MichaelBroschat@discussions.microsoft.com> wrote in
message news:E373C876-5C48-4229-95F8-46F61857FB0C@microsoft.com...
Our network (which includes an STS server) is changing domains. We have
decided to duplicate project users (within the SQL Server database),
changing
their domain designation to the new one (and thereby leaving the old
identity, too).
I can do this, but I can't see how to assign any permissions at all. In
other words, if OldDomain\Ralph gets a new identity as NewDomain\Ralph,
how
can I programmatically give him the same permissions as OldDomain\Ralph
has?
I see how project data is stored in the SQL Server database but cannot
find
any reference to the various permissions levels.
Thanks in advance...
|
|
|
| Back to top |
|
 |
Mike Walsh
Guest
|
Posted:
Mon Dec 27, 2004 10:35 pm Post subject:
Re: Duplicating permissions for a different domain |
|
|
True in many cases. In this case with the application replaced over a year
ago, I wonder how many more times you are going to change domains in its
lifetime.
There might of course be someone just waiting for their chance to tell you
how to do it. But recently there's only been myself and Roger who have been
even trying to answer STS questions here, so you might have a long wait.
(Thanks for the SP3 info - I haven't bothered moving my old sites to SP3,
they're still at SP2)
Mike Walsh, Helsinki, Finland
"Michael Broschat" <MichaelBroschat@discussions.microsoft.com> wrote in
message news:6E73C978-5BD3-492B-95BD-8150A6282739@microsoft.com...
| Quote: | Thanks, Mike. I was afraid that the manual approach would be the only
viable
alternative.
Investigating how to do something (even when it takes longer than doing it
manually) often pays in the future, when you least expect it. Besides, I
maintain that there is no fun in administration, and if you can't think of
some way to make it interesting, you're probably not going to do it much
longer. And certainly not very well...
Broschat
"Mike Walsh" wrote:
I wouldn't advise making amendments to the database directly and given
that
I can't think how to do what you want programmatically, I would
personally
just bite the bullet and
a) print out the users assigned to each different authentication part of
the
site (thus getting name and permissions)
and
b) add the permissions by hand
But then people have complained before that they want a programming
solution
even if it takes longer in total (including investigating how to do it)
...
Mike Walsh, Helsinki, Finland
"Michael Broschat" <MichaelBroschat@discussions.microsoft.com> wrote in
message news:7289E5C0-2AF5-4FD8-AD5D-C2502AEEA636@microsoft.com...
That is correct. This "project" has absolutely nothing to do with
Project
and
is entirely within the scope of SharePoint Team Services (ie, the old
one),
to which we've applied SP3, by the way.
"Mike Walsh" wrote:
Can you please just confirm that your use of "project" does not have
anything to do with Project Server and that you are using STS v 1.0
which
came out in 2001.
Mike Walsh, Helsinki, Finland
STS FAQ at http://www.collutions.com/Lists/FAQ
WSS FAQ at http://wss.collutions.com
Please reply to the newsgroup
"Michael Broschat" <MichaelBroschat@discussions.microsoft.com> wrote
in
message news:E373C876-5C48-4229-95F8-46F61857FB0C@microsoft.com...
Our network (which includes an STS server) is changing domains. We
have
decided to duplicate project users (within the SQL Server database),
changing
their domain designation to the new one (and thereby leaving the old
identity, too).
I can do this, but I can't see how to assign any permissions at all.
In
other words, if OldDomain\Ralph gets a new identity as
NewDomain\Ralph,
how
can I programmatically give him the same permissions as
OldDomain\Ralph
has?
I see how project data is stored in the SQL Server database but
cannot
find
any reference to the various permissions levels.
Thanks in advance...
|
|
|
| Back to top |
|
 |
|
|
|
|