Explicit permissions listed twice
- From: David Walker <none@xxxxxxxx>
- Date: Fri, 11 Apr 2008 17:55:24 -0700
In one of our databases, under Security/Users, when I look at the
Properties for a particular user, and select the Securables page, each of
the permissions is listed twice...
Once with grantor "dbo" and once with grantor "db_owner". The permissions
that were granted by "dbo" do not have Grant, With Grant, or Deny checked.
So, they are kind of empty.
Is this normal? Should I remove the explicit permissions that were granted
by dbo? If so, how? I don't see a way from the GUI in Management Studio
to remove these rows. If they are normal, I won't worry about them.
Thanks.
David Walker
.
- Follow-Ups:
- Re: Explicit permissions listed twice
- From: Erland Sommarskog
- Re: Explicit permissions listed twice
- Prev by Date: Alter schema on user-defined data type?
- Next by Date: Re: Explicit permissions listed twice
- Previous by thread: Alter schema on user-defined data type?
- Next by thread: Re: Explicit permissions listed twice
- Index(es):
Relevant Pages
|
|