Options
Grants missing from Views
Brian Donahue
Posts: 6,590 Bronze 1
Hi Sylvain,
Just a few things to be aware of: Make sure that you haven't selected
'Ignore object permissions' in the View->Options, and also be aware that the
only permissions that get scripted are ones that specifically apply to that
object, ie if someone can access the object because they have a SYSADMIN
role, that won't be scripted.
Regards,
Brian Donahue
Technical Support
"Sylvain Léger" <sleger@uapinc.com> wrote in message
news:H12uYwLPDHA.1452@server53...
> Hi,
> I am using version 2.02 and I have a problem when I use 'Create change
> scripts'. The 'Grants' are missing from the script for views (tables, SP
> and functions are OK). I tried selecting everything because I thought it
> was a dependencies problem. I hope I am doing something wrong.
>
> Thanks,
> Sylvain
>
>
Just a few things to be aware of: Make sure that you haven't selected
'Ignore object permissions' in the View->Options, and also be aware that the
only permissions that get scripted are ones that specifically apply to that
object, ie if someone can access the object because they have a SYSADMIN
role, that won't be scripted.
Regards,
Brian Donahue
Technical Support
"Sylvain Léger" <sleger@uapinc.com> wrote in message
news:H12uYwLPDHA.1452@server53...
> Hi,
> I am using version 2.02 and I have a problem when I use 'Create change
> scripts'. The 'Grants' are missing from the script for views (tables, SP
> and functions are OK). I tried selecting everything because I thought it
> was a dependencies problem. I hope I am doing something wrong.
>
> Thanks,
> Sylvain
>
>
This discussion has been closed.
