Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Implementing security in user table as implemented in sysobjects

4 posts in General Discussion Last posting was on 2009-11-20 11:54:38.0Z
Nishant Rupani Posted on 2009-11-20 08:54:24.0Z
From: Nishant Rupani <nishant.rupani@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Implementing security in user table as implemented in sysobjects
Date: Fri, 20 Nov 2009 00:54:24 -0800 (PST)
Organization: http://groups.google.com
Lines: 15
Message-ID: <5d257561-01b2-4429-b3cb-14fefa4519b1@r24g2000prf.googlegroups.com>
NNTP-Posting-Host: 203.201.251.144
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1258707264 22702 127.0.0.1 (20 Nov 2009 08:54:24 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 20 Nov 2009 08:54:24 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: r24g2000prf.googlegroups.com; posting-host=203.201.251.144; posting-account=y-Y-8QoAAABzR4Wr8eYwc4ZkHK7jRXT_
User-Agent: G2/1.0
X-HTTP-Via: 1.1 tiipx1:8080 (DataReactor/4.1.0p24d2), 1.1 tiipx2:8080 (DataReactor/4.1.0p24d2)
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; MSBrowserIE7; Windows NT 5.1; msie6xpv1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; MS-RTC LM 8),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!r24g2000prf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28657
Article PK: 77897

Hi All,

When we execute below query it gives error saying "SELECT permission
denied on column audflags "

Query: select * from sysobjects
Error: Server Message: Number 10332, Severity 14
SELECT permission denied on column audflags of object sysobjects,
database cis_db, owner dbo

How can I implement this kind of security on other user tables as
well?

Regards,
Nishant


Nishant Rupani Posted on 2009-11-20 10:46:43.0Z
From: Nishant Rupani <nishant.rupani@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Implementing security in user table as implemented in sysobjects
Date: Fri, 20 Nov 2009 02:46:43 -0800 (PST)
Organization: http://groups.google.com
Lines: 4
Message-ID: <b39ac4c8-2aed-4ce5-84cc-3538f709f782@g1g2000pra.googlegroups.com>
References: <5d257561-01b2-4429-b3cb-14fefa4519b1@r24g2000prf.googlegroups.com>
NNTP-Posting-Host: 203.201.251.144
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1258714003 8827 127.0.0.1 (20 Nov 2009 10:46:43 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 20 Nov 2009 10:46:43 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: g1g2000pra.googlegroups.com; posting-host=203.201.251.144; posting-account=y-Y-8QoAAABzR4Wr8eYwc4ZkHK7jRXT_
User-Agent: G2/1.0
X-HTTP-Via: 1.1 tiipx1:8080 (DataReactor/4.1.0p24d2), 1.1 tiipx2:8080 (DataReactor/4.1.0p24d2)
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; MSBrowserIE7; Windows NT 5.1; msie6xpv1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; MS-RTC LM 8),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!newsfeed.news2me.com!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g1g2000pra.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28658
Article PK: 77902

By this, I meant the column level security. Thanks.

Regards,
Nishant


Carl Kayser Posted on 2009-11-20 11:01:51.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <5d257561-01b2-4429-b3cb-14fefa4519b1@r24g2000prf.googlegroups.com> <b39ac4c8-2aed-4ce5-84cc-3538f709f782@g1g2000pra.googlegroups.com>
Subject: Re: Implementing security in user table as implemented in sysobjects
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3598
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b06771f$1@forums-1-dub>
Date: 20 Nov 2009 03:01:51 -0800
X-Trace: forums-1-dub 1258714911 10.22.241.152 (20 Nov 2009 03:01:51 -0800)
X-Original-Trace: 20 Nov 2009 03:01:51 -0800, vip152.sybase.com
X-Authenticated-User: ase1251
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28659
Article PK: 77900


"Nishant Rupani" <nishant.rupani@gmail.com> wrote in message
news:b39ac4c8-2aed-4ce5-84cc-3538f709f782@g1g2000pra.googlegroups.com...
> By this, I meant the column level security. Thanks.
>
> Regards,
> Nishant

[grant | revoke] [delete | insert | select | update] on [table | view]
to/from [user | group | role]

[grant | revoke] [select | update] on [table | view] (column-list) to/from
[user | group | role]

But you should plan the overall scheme that you want to end up with. Will
you use group or role level security? Or (ugh) a mix of the two? Etc.
See, for example, chapters 12-19 at
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc31654.1502/pdf/sag1.pdf


Nishant Rupani Posted on 2009-11-20 11:54:38.0Z
From: Nishant Rupani <nishant.rupani@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Implementing security in user table as implemented in sysobjects
Date: Fri, 20 Nov 2009 03:54:38 -0800 (PST)
Organization: http://groups.google.com
Lines: 3
Message-ID: <afffd5e6-f4c6-457c-8d41-b9728b928e57@z3g2000prd.googlegroups.com>
References: <5d257561-01b2-4429-b3cb-14fefa4519b1@r24g2000prf.googlegroups.com> <b39ac4c8-2aed-4ce5-84cc-3538f709f782@g1g2000pra.googlegroups.com> <4b06771f$1@forums-1-dub>
NNTP-Posting-Host: 203.201.251.144
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1258718078 32487 127.0.0.1 (20 Nov 2009 11:54:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 20 Nov 2009 11:54:38 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: z3g2000prd.googlegroups.com; posting-host=203.201.251.144; posting-account=y-Y-8QoAAABzR4Wr8eYwc4ZkHK7jRXT_
User-Agent: G2/1.0
X-HTTP-Via: 1.1 tiipx1:8080 (DataReactor/4.1.0p24d2), 1.1 tiipx2:8080 (DataReactor/4.1.0p24d2)
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; MSBrowserIE7; Windows NT 5.1; msie6xpv1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; MS-RTC LM 8),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!transit3.readnews.com!postnews.google.com!z3g2000prd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28660
Article PK: 77901

got it. thanks.

- Nishant