Re: Permission settings for views to be created
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Mon, 13 Nov 2006 09:41:46 +0200
Tom
Do I really have to specifically set permissions for every table and
view and not just specify a default setting for all views and table in
a database?
You can GRANT SELECT ... on database level , take a look at GRANT topic in
the BOL
"Tom" <tom.kostiainen@xxxxxxxxxxxxx> wrote in message
news:1163403167.187392.286270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Using a schema I can deny or grant permissions to use the alter
command, but not specifically grant alter for any view (existing or to
be created) AND deny alter for any table. I can only either grant or
deny alter, right?
Do I really have to specifically set permissions for every table and
view and not just specify a default setting for all views and table in
a database?
Uri Dimant wrote:
Tom
GRANT SELECT on SCHENA ........ GRANT SELECT on VIEW ..... . (See
details
in the BOL) .
Do the users have SSMS installed on their workstations?
"Tom" <tom.kostiainen@xxxxxxxxxxxxx> wrote in message
news:1163166994.843815.142270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I'm a beginner when it comes to SQL Server 2005 and user permissions.
I'm wondering, how do I set the default rights for views yet to be
created? I've only find a way to configure the already existing views.
Br,
Tom
.
- References:
- Permission settings for views to be created
- From: Tom
- Re: Permission settings for views to be created
- From: Uri Dimant
- Re: Permission settings for views to be created
- From: Tom
- Permission settings for views to be created
- Prev by Date: Re: Permission settings for views to be created
- Next by Date: Re: MDF Password
- Previous by thread: Re: Permission settings for views to be created
- Next by thread: Effect of removing LocalSystem from sysadmin role?
- Index(es):
Relevant Pages
|
|
