Conflict of Permissions by NT Groups

Hi,

This is regarding permission issue in windows-authenticated sql server 2000.

I have two NT groups namely A & B.

Groups A has all permissions on SQLDB1 while group B has all on SQLDB1 and SQLDB2.

Since I dont want B to have INS/UPD/DEL rights on SQLDB1, I revoked those permissions for B on the same. But users belonging to both groups suffer INS/UPD/DEL rights on SQLDB1.

Could anyone help please ?

Thanks in advance.

Use DENY instead of REVOKE.

--

Tibor Karaszi, SQL Server MVP

http://www.karaszi.com/sqlserver/default.asp

http://www.solidqualitylearning.com/

Blog: http://solidqualitylearning.com/blogs/tibor/

wrote in message

news:2d0faecd-406e-4bcd-9aba-70fc886637ce@.discussions.microsoft.com...

> Hi,

>

> This is regarding permission issue in windows-authenticated sql server

> 2000.

>

> I have two NT groups namely A & B.

>

> Groups A has all permissions on SQLDB1 while group B has all on SQLDB1

> and SQLDB2.

>

> Since I dont want B to have INS/UPD/DEL rights on SQLDB1, I revoked

> those permissions for B on the same. But users belonging to both groups

> suffer INS/UPD/DEL rights on SQLDB1.

>

> Could anyone help please ?

>

> Thanks in advance.

>

>|||

I tried DENY too. Result is the same as before.

|||

Can you explain in more detail what commands you executed? Also, can you check the catalog to verify that permissions are granted/denied as intended. The database permissions catalog is sys.database_permissions.

Thanks
Laurentiu

|||There is no such a table called sys.database_permissions in sql server 2000. Thanks.|||

In SQL 2000 you can use sysprotects. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-p_0837.asp, for a description.

Thanks
Laurentiu

Conflict of Permissions by NT Groups

Hi,

This is regarding permission issue in windows-authenticated sql server 2000.

I have two NT groups namely A & B.

Groups A has all permissions on SQLDB1 while group B has all on SQLDB1 and SQLDB2.

Since I dont want B to have INS/UPD/DEL rights on SQLDB1, I revoked those permissions for B on the same. But users belonging to both groups suffer INS/UPD/DEL rights on SQLDB1.

Could anyone help please ?

Thanks in advance.

Use DENY instead of REVOKE.

--

Tibor Karaszi, SQL Server MVP

http://www.karaszi.com/sqlserver/default.asp

http://www.solidqualitylearning.com/

Blog: http://solidqualitylearning.com/blogs/tibor/

wrote in message

news:2d0faecd-406e-4bcd-9aba-70fc886637ce@.discussions.microsoft.com...

> Hi,

>

> This is regarding permission issue in windows-authenticated sql server

> 2000.

>

> I have two NT groups namely A & B.

>

> Groups A has all permissions on SQLDB1 while group B has all on SQLDB1

> and SQLDB2.

>

> Since I dont want B to have INS/UPD/DEL rights on SQLDB1, I revoked

> those permissions for B on the same. But users belonging to both groups

> suffer INS/UPD/DEL rights on SQLDB1.

>

> Could anyone help please ?

>

> Thanks in advance.

>

>|||

I tried DENY too. Result is the same as before.

|||

Can you explain in more detail what commands you executed? Also, can you check the catalog to verify that permissions are granted/denied as intended. The database permissions catalog is sys.database_permissions.

Thanks
Laurentiu

|||There is no such a table called sys.database_permissions in sql server 2000. Thanks.|||

In SQL 2000 you can use sysprotects. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-p_0837.asp, for a description.

Thanks
Laurentiu

Confined by table cells .. Col span option?

Under a table with headers, groups, details and footers .. say I want
two sets of details that should not align with the headers. Or for
example, say I have a subreport in a group that I would lke to span the
entire width of the the table.. How do I do this?
Thansk.Have you tried merging the cells?
"jobs" <jobs@.webdos.com> wrote in message
news:1162310445.109140.233360@.m73g2000cwd.googlegroups.com...
> Under a table with headers, groups, details and footers .. say I want
> two sets of details that should not align with the headers. Or for
> example, say I have a subreport in a group that I would lke to span the
> entire width of the the table.. How do I do this?
> Thansk.
>|||Noob here. How do you select more than one cell so the merge option is
enabled? shift right arrow does not seem to work for me and I can't
seem to lasso inside a table.
Sebasti=E1n G=F3mez wrote:
> Have you tried merging the cells?
> "jobs" <jobs@.webdos.com> wrote in message
> news:1162310445.109140.233360@.m73g2000cwd.googlegroups.com...
> >
> > Under a table with headers, groups, details and footers .. say I want
> > two sets of details that should not align with the headers. Or for
> > example, say I have a subreport in a group that I would lke to span the
> > entire width of the the table.. How do I do this?
> >
> > Thansk.
> >|||Select the cells you want to merge, then right click 'Merge Cells'.
"jobs" wrote:
> Noob here. How do you select more than one cell so the merge option is
> enabled? shift right arrow does not seem to work for me and I can't
> seem to lasso inside a table.
> Sebastián Gómez wrote:
> > Have you tried merging the cells?
> >
> > "jobs" <jobs@.webdos.com> wrote in message
> > news:1162310445.109140.233360@.m73g2000cwd.googlegroups.com...
> > >
> > > Under a table with headers, groups, details and footers .. say I want
> > > two sets of details that should not align with the headers. Or for
> > > example, say I have a subreport in a group that I would lke to span the
> > > entire width of the the table.. How do I do this?
> > >
> > > Thansk.
> > >
>

Configuring Peer-to_Peer Merge Replication

We have a situation almost exactly like that in the MS documentation
vis a vis peer-to-peer replication. We have three servers and three
user groups, one each in Chicago, New York, and Bermuda. Because of our
business practices, we are fairly confident that only one group will be
updating a given record at any one time but the users will be updating
their own local database servers and those updates must appear on all
three servers. Reading through the documentation, MS seems to recommend
peer-to-peer merge replication. Unfortunately, the documenation then
goes off and gives an example only of transaction replication without
updating subscriptions. Well, OK I sez, I'll just adpat what the docs
say but select merge replication. Doesn't work that way. Using SQL
studio, I have never been able to get to a peer-to-peer topology option
using anything but transaction replicas without updating subscriptions.
Using T-SQL, it looks like I can brute force peer to peer replication
with updating subscriptions but the sp_addmergedpublication function
does not have any options for peer-to-peer topology.
So, what gives? How do I set up peer-to-peer merge replication? Any
help would be greatly appreciated!
Thanks.
RandyThere did you read about Peer-to_Peer Merge Replication ?
I checked both BOL and the courseware and it only talks about
peer-to-peer transactional.

Markus