Re: Permission problems user can't create a table
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Thu, 28 Jun 2007 15:43:10 +0300
See if this helps you
select [Role] = r.name, [Member] = m.name
from sys.database_role_members rm
join sys.database_principals r on rm.role_principal_id = r.principal_id
join sys.database_principals m on
rm.member_principal_id = m.principal_id
order by r.name, m.name
<frant101@xxxxxxxxxxxxxx> wrote in message
news:1183034160.704628.192090@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks Dan,
It confused me that you could add the create table permisson to a user
and they didnt have permissons to create a table structure ( seems a
bit strange to me)
If I wanted a user to be able to create tables in a database in all
schema's what is the best way to do that ?
and how can i view which users are in what database / server roles ?
Thanks
Francis
.
- References:
- Permission problems user can't create a table
- From: frant101
- Re: Permission problems user can't create a table
- From: Uri Dimant
- Re: Permission problems user can't create a table
- From: frant101
- Re: Permission problems user can't create a table
- From: Uri Dimant
- Re: Permission problems user can't create a table
- From: frant101
- Re: Permission problems user can't create a table
- From: Dan Guzman
- Re: Permission problems user can't create a table
- From: frant101
- Permission problems user can't create a table
- Prev by Date: Re: Permission problems user can't create a table
- Next by Date: Re: Permission problems user can't create a table
- Previous by thread: Re: Permission problems user can't create a table
- Next by thread: Re: Permission problems user can't create a table
- Index(es):
Relevant Pages
|
|
