Re: major security concern - any sql user with minimal permission can see code for all stored procs and triggers

From: Pankul Verma (pankul@urbanwireless.com)
Date: 05/17/02 

From: "Pankul Verma" <pankul@urbanwireless.com>
Date: Fri, 17 May 2002 12:49:15 -0400

I'd like someone from MS SQL Server Security group to comment. I am sure
they had a reason to do so, or have a workaround

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:kai5eukie62vt8np4ldff38hgvdfqkj4e5@4ax.com...
> Something like that would work. Just add the user to this
> new database and make sure you don't have the guest account
> enabled in any of the databases that you don't want the user
> to have access to.
>
> -Sue

Relevant Pages

  • compiler and metadata, request opinions...
    ... a lot of the upper/middle compiler machinery is still lacking (such as ... embed the metadata directly into the object modules (the reason being that ... request for a particular piece of information is embedded in a symbol (sort ... it will be loaded into an in-memory version of the database. ...
    (comp.compilers)
  • misc: compiler and metadata...
    ... a lot of the upper/middle compiler machinery is still lacking (such as ... embed the metadata directly into the object modules (the reason being that ... request for a particular piece of information is embedded in a symbol (sort ... it will be loaded into an in-memory version of the database. ...
    (comp.lang.misc)
  • RE: how to list LE options
    ... for whatever reason an applications programmer has to look at this ... curiousity and desire to expand their knowledge, there is no real reason ... LE options were copied to an application parmlib, ... There's no reason that Database, CICS and other groups can't maintain ...
    (bit.listserv.ibm-main)
  • RE: [dbi] RE: Accessing MS Access through the DBI ODBC
    ... reason for this issue is the mdb is on a mapped drive where the mapped driver ... > still getting 'Unable to connect to database'. ... > use DBI; ... Then it will simply display it and die since there ...
    (perl.dbi.users)
  • Re: Stupid Database Tricks
    ... You are describing a possible workaround, ... Cascading updates can cause other problems, ... to have to handle a deadlock every time we touch the database. ... might end up rewriting history! ...
    (comp.databases.theory)