|
Home > Archive > IQ Server > September 2005 > Revoking Select From Particular Columns?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Revoking Select From Particular Columns?
|
|
| Brainyguy9999 2005-09-19, 1:26 pm |
|
Good day. I have been able to revoke and grant select
rights to various users and groups on tables, but have not
had any luck revoking select access on particular columns in
a table. I get a "you don't have permission to revoke"
rights on the particular table. I can grant/revoke as the
next command under the same ID to the whole table in
question but not on a particular column within that table.
Has anyone had any luck/experience revoking (or hiding)
particular columns from certain users/groups?
Thanks.
bg
| |
| Carl Kayser 2005-09-20, 8:24 pm |
| It might be of interest to know which ASIQ version you are using.
Are you the owner of the table? If not, are you are you simply granted
permissions or, more likely, been granted "with grant"? Or possibly a
combination of the two?
<Brainyguy9999> wrote in message news:432efca0.3496.1681692777@sybase.com...
>
> Good day. I have been able to revoke and grant select
> rights to various users and groups on tables, but have not
> had any luck revoking select access on particular columns in
> a table. I get a "you don't have permission to revoke"
> rights on the particular table. I can grant/revoke as the
> next command under the same ID to the whole table in
> question but not on a particular column within that table.
>
> Has anyone had any luck/experience revoking (or hiding)
> particular columns from certain users/groups?
>
> Thanks.
>
> bg
| |
| BrainyGuy9999 2005-09-28, 11:24 am |
|
We are using ASIQ 12.5 ESD 11. I failed to mention in this
post that I have tried as both DBA and table owner
(resource).
Thanks.
bg
> It might be of interest to know which ASIQ version you are
> using.
>
> Are you the owner of the table? If not, are you are you
> simply granted permissions or, more likely, been granted
> "with grant"? Or possibly a combination of the two?
>
> <Brainyguy9999> wrote in message
> news:432efca0.3496.1681692777@sybase.com... >
> column within that table. >
>
>
|
|
|
|
|