I have an error that states....
DESCRIPTION:Replication-Replication Merge Subsystem: agent R99S-SQLA-
EDI-EDI Merge to 00-r00s-sqla-2 failed. Publication 'EDI Merge to 00'
does not exist.
Due to the fact that there are other consultants setting up/deleteing
replication & do not know how this happened...nonetheless I need to
delete this replication. The publication is not in the tree list in
Local Publications, so I have no way of getting rid of it from there.
I have done some research & I am suppose to look in the
MSmerge_publications table in the distribution dB, but I do not have a
distribution dB.
Any one have a clue about this one?
Larry...
Looks like someone has created a publication from script that has spaces in
the name. You have to delete this publication, and then recreate it
correctly.
You will probably have to edit the system tables to do this.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1185813236.584431.209930@.19g2000hsx.googlegro ups.com...
>I have an error that states....
> DESCRIPTION: Replication-Replication Merge Subsystem: agent R99S-SQLA-
> EDI-EDI Merge to 00-r00s-sqla-2 failed. Publication 'EDI Merge to 00'
> does not exist.
> Due to the fact that there are other consultants setting up/deleteing
> replication & do not know how this happened...nonetheless I need to
> delete this replication. The publication is not in the tree list in
> Local Publications, so I have no way of getting rid of it from there.
>
> I have done some research & I am suppose to look in the
> MSmerge_publications table in the distribution dB, but I do not have a
> distribution dB.
> Any one have a clue about this one?
> Larry...
>
Showing posts with label states. Show all posts
Showing posts with label states. Show all posts
Saturday, February 25, 2012
Monday, February 20, 2012
Public Role
In BOL (regarding the Public Role) it states, as one of its functions:
"Captures all default permissions for users in a database."
How does one assign default permissions for a user?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200511/1
Every user in a database has, by default, the permissions granted to the
public role. So, you grant permissions to the user by granting permissions to
the public role. But ...
From BOL "A user receives the union of all the permissions granted, denied,
or revoked on an object, with any denied permissions taking precedence over
the same permissions granted or revoked at another level".
Ben Nevarez
"Robert R via droptable.com" wrote:
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200511/1
>
|||Ben explained how all users inherit permissions from the public rile. I'd
like to add that you might consider using user-defined roles instead of
public so that you can more granularly control security. Personally, I only
use the public role for default system catalog permissions.
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:5775935dde74c@.uwe...
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200511/1
"Captures all default permissions for users in a database."
How does one assign default permissions for a user?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200511/1
Every user in a database has, by default, the permissions granted to the
public role. So, you grant permissions to the user by granting permissions to
the public role. But ...
From BOL "A user receives the union of all the permissions granted, denied,
or revoked on an object, with any denied permissions taking precedence over
the same permissions granted or revoked at another level".
Ben Nevarez
"Robert R via droptable.com" wrote:
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200511/1
>
|||Ben explained how all users inherit permissions from the public rile. I'd
like to add that you might consider using user-defined roles instead of
public so that you can more granularly control security. Personally, I only
use the public role for default system catalog permissions.
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:5775935dde74c@.uwe...
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200511/1
Public Role
In BOL (regarding the Public Role) it states, as one of its functions:
"Captures all default permissions for users in a database."
How does one assign default permissions for a user?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200511/1Every user in a database has, by default, the permissions granted to the
public role. So, you grant permissions to the user by granting permissions t
o
the public role. But ...
From BOL "A user receives the union of all the permissions granted, denied,
or revoked on an object, with any denied permissions taking precedence over
the same permissions granted or revoked at another level".
Ben Nevarez
"Robert R via droptable.com" wrote:
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200511/1
>|||Ben explained how all users inherit permissions from the public rile. I'd
like to add that you might consider using user-defined roles instead of
public so that you can more granularly control security. Personally, I only
use the public role for default system catalog permissions.
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:5775935dde74c@.uwe...
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200511/1
"Captures all default permissions for users in a database."
How does one assign default permissions for a user?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200511/1Every user in a database has, by default, the permissions granted to the
public role. So, you grant permissions to the user by granting permissions t
o
the public role. But ...
From BOL "A user receives the union of all the permissions granted, denied,
or revoked on an object, with any denied permissions taking precedence over
the same permissions granted or revoked at another level".
Ben Nevarez
"Robert R via droptable.com" wrote:
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200511/1
>|||Ben explained how all users inherit permissions from the public rile. I'd
like to add that you might consider using user-defined roles instead of
public so that you can more granularly control security. Personally, I only
use the public role for default system catalog permissions.
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:5775935dde74c@.uwe...
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200511/1
Public Role
In BOL (regarding the Public Role) it states, as one of its functions:
"Captures all default permissions for users in a database."
How does one assign default permissions for a user?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200511/1Every user in a database has, by default, the permissions granted to the
public role. So, you grant permissions to the user by granting permissions to
the public role. But ...
From BOL "A user receives the union of all the permissions granted, denied,
or revoked on an object, with any denied permissions taking precedence over
the same permissions granted or revoked at another level".
Ben Nevarez
"Robert R via SQLMonster.com" wrote:
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200511/1
>|||Ben explained how all users inherit permissions from the public rile. I'd
like to add that you might consider using user-defined roles instead of
public so that you can more granularly control security. Personally, I only
use the public role for default system catalog permissions.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert R via SQLMonster.com" <u3288@.uwe> wrote in message
news:5775935dde74c@.uwe...
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200511/1
"Captures all default permissions for users in a database."
How does one assign default permissions for a user?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200511/1Every user in a database has, by default, the permissions granted to the
public role. So, you grant permissions to the user by granting permissions to
the public role. But ...
From BOL "A user receives the union of all the permissions granted, denied,
or revoked on an object, with any denied permissions taking precedence over
the same permissions granted or revoked at another level".
Ben Nevarez
"Robert R via SQLMonster.com" wrote:
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200511/1
>|||Ben explained how all users inherit permissions from the public rile. I'd
like to add that you might consider using user-defined roles instead of
public so that you can more granularly control security. Personally, I only
use the public role for default system catalog permissions.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert R via SQLMonster.com" <u3288@.uwe> wrote in message
news:5775935dde74c@.uwe...
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200511/1
Subscribe to:
Posts (Atom)