How to determine the current user's rights

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bob Trabucco (bobt_at_ccc-soft.com)
Date: 11/08/04 

Date: Mon, 8 Nov 2004 14:57:41 -0500

Hi all,

My .NET application needs to know if the currently logged on user has rights
enough to create global tables, indexes, stored procedures, views, etc in
the current database.

The program runs through routines that create all these tables and we have
to make sure there is sufficient permission to create these items for all
users of the database to use.

Is there any defined stored procedures or views that returns that kind of
system information?

Thanks you!

Bob Trabucco
Coastal Computer Corporation

Relevant Pages

  • Re: Database Model - Class, objects and interaction
    ... I was just proving stored procedures can call views. ... stuff like security and logging. ... So given 100,000 users, you would create database accounts for each? ... Part of our system's integrity was its reliability, and reliability is often assisted by simplicity. ...
    (comp.object)
  • Re: Database Model - Class, objects and interaction
    ... Stored procedures should only be used as a last resort if you cant use ... I've not said that views shouldn't be created, only that they shouldn't be exposed as the interface to the database. ... But business rules can be more complicated than simply defining overdue invoices. ...
    (comp.object)
  • Re: Infinite Loops and Explicit Exits
    ... the whole payroll system would be dependent on proper database ... I design large systems the same way. ... Stored procedures ARE application code. ... any language, including Cobol. ...
    (comp.lang.cobol)
  • Re: Data security
    ... look into using Stored procedures. ... > database. ... > the database and revoke rights at tat moment in time? ... > developers are developing and be comfortable that the data is secure? ...
    (microsoft.public.sqlserver.security)
  • Re: Identity Column
    ... the end use is using Crystal Reports - where is the magic? ... The user will connect using Active Directory from their desktop to the database server or do please explain the magic.... ... Using stored procedures you permission on the stored proc only; the user can only execute the stored procedure with the parameters defined, there is no select * from to get all the information in your database. ...
    (microsoft.public.sqlserver.programming)