User mangement for a database applicaiton

From: Prakash K Reddy (itbanarly@simbaonline.net)
Date: 05/04/02 

From: "Prakash K Reddy" <itbanarly@simbaonline.net>
Date: Sat, 4 May 2002 11:57:46 +0100

Hi Guys,

I am planning for a database application using VB 6 and SQL SERVER 2000.I
have a problem with me. How to mange the security . w.r.t to User access to
the database.I find that there is no requirement of creating users in the
database,since no user has the knowledge of writing sql’s.So what I am
thinking is to restrict the user thru vb code.That is by making the
particular menu visible or not visible according to the user id and
password.I will create a table in the databse which will hold the different
menus with a row for different operations like editing,creating,updating,
etcc..

Will this work

Any other suggestions

Regds

Prakash

Relevant Pages

  • Re: Securing short hand views in SQL/MP
    ... >Rob Lesan wrote: ... >> Dave, I see what you are trying to say here, but what I want to accomplish is ... >columns without changing security on the tables to "NNNN". ... a user access to ONLY the view and NEVER the underlying table. ...
    (comp.sys.tandem)
  • Re: Securing short hand views in SQL/MP
    ... This allows the DBA to give a user access to ONLY the view and NEVER the underlying table. ... What you are saying is that your DBA is trustd to set security policy with regards to data access but is not given the tools to do it - correct? ...
    (comp.sys.tandem)
  • Re: Column-level Security
    ... the thing with this approach is that the _view_ is the security. ... - Disallow any user access to the table. ... On SQL Server 2005 at least, my tests indicate that my WHERE only sees the ... The SELECT permission was denied on the column ... ...
    (microsoft.public.sqlserver.security)
  • Re: User security + mde question
    ... security (just use the MDW to manage user access), ... since MS called the account "admin" it seems that their original ...
    (comp.databases.ms-access)
  • Re: Allowing a non-admin user run a program
    ... without an admin password. ... installed in, click on the Security tab, the click on the "Edit" ... The User Access Control warning here is actually a result not of the ... typing program itself, but of the file "ISI Updater.exe". ...
    (microsoft.public.windows.vista.administration_accounts_passwords)
Quantcast