Re: public role question

What does the query 'SELECT USER' return?

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Dan D." <DanD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2E69E961-1C77-4B9D-9962-F4C11B7017EB@xxxxxxxxxxxxxxxx
In the new database that I created, I was able to create a stored
procedure.
I ran EXEC sp_helprotect NULL, 'public' but I don't see the "create
procedure" permisson listed under the action column. How am I able to
create
a stored procedure with a user that is only a member of public and has no
other permissions?
--
Dan D.


"Dan D." wrote:

Using SS2000 SP4. I'm trying to lock down the database as much as
possible. I
created a new sql server login and gave the user no permissions other
than
public role.

Why am I able to create a stored procedure with the new user. I thought
Public had select, insert, update, delete permissions. Does that allow a
user
to create a stored procedure?

Thanks,
--
Dan D.


.

Relevant Pages

  • Re: public role question
    ... The user dbo is a privileged user and can create tables and procs, ... permissions from the user dbo. ... "Dan Guzman" wrote: ... Why am I able to create a stored procedure with the new user. ...
    (microsoft.public.sqlserver.security)
  • Re: public role question
    ... Dan, I'm sorry but after I responded to Kalen's email I deleted the test ... Somehow the user 'dantest' was the owner of the database so I guess ... I did create a second user with only the public role for permissions and was ... Then I am able to create a stored procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: public role question
    ... I didn't understand what Dan was asking me to do. ... Then I am able to create a stored procedure. ... system tables with select permissions. ... You ARE the special DBO user, and not the new user, which is why you have ...
    (microsoft.public.sqlserver.security)
  • Re: INFORMATION_SCHEMA permissions
    ... Dan, ... The definition of the INFORMATION_SCHEMA views are, in SQL Server ... can be cut and pasted into Query Analyzer is appreciated. ... > the user must have select permissions on the table. ...
    (microsoft.public.sqlserver.security)
  • Re: public role question
    ... Dan Guzman ... permissions is that users are members of the 'BUILTIN\Administrators' ... Then I am able to create a stored procedure. ... The user dbo is a privileged user and can create tables and procs, ...
    (microsoft.public.sqlserver.security)