Re: Permission in database

From: Christian Olsson (christian.olsson@protegrity.com)
Date: 08/23/02 

From: christian.olsson@protegrity.com (Christian Olsson)
Date: 22 Aug 2002 22:55:56 -0700

Secure.Data™ for SQL Server 2000 is an "out-of-the-box" automated
database encryption solution with protected key-management software
for selectively encrypting, securing and controlling access to
enterprise relational database information at the data-item level.
This database security solution is application transparent, which
allows for fast integration, rapid execution, cost-effective security
and privacy compliance. The Solution provides an effective last line
of defense:
 
· Selective and highly secure, column-level data item
encryption

· Cryptographically enforced authorization

· Comprehensive key management

· Secure audit and reporting facility

· Enforced separation of duties

· Interoperability with other security technologies

· Operational transparency to applications

For more info see: www.protegrity.com/microsoft

"Shailesh" <shailesh@geminicorp.be> wrote in message news:<02af01c239fa$10d9c670$3bef2ecf@TKMSFTNGXA10>...
> Dear Friends
>
> My company is having database in access and due to that
> reason the performance is very slow.Hence we have decided
> to go for the SQL server.
>
> With the upsize wizard in MS-Access I have made all the
> tables and funtions which are working very fine but the
> only problem i have is to give permission.
>
> I have 25 users working on the same database which
> includes the table of
>
> 1) Sales
> 2) Purchases
> 3) Customer
>
> And following are my users ( Groups )
>
> 1) Administrator -: One who can do anything in the
> database.
>
> 2) Only Read permission users on all Tables
>
> 3) AccountDep : Who update the database of Sales and
> Purchase but not customer they have only right of Read on
> the purchases.
>
> 4) Sales Person: Who Update the Table of Sales ..
>
> Kindly suggest how i can give the permission to all so
> that there will not be any security laps.
>
> Your reply will help me to perform best.
>
> Thanks in Advance

Relevant Pages

  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cryptography in SQL Server 2000
    ... A company is vulnerable when its security ... > database encryption solution with protected key-management software ... > tested by the SQL Server Test Lab. ...
    (microsoft.public.sqlserver.security)
  • Re: How to prevent importing tables
    ... why in-built encryption doesn't even matter if they otherwise have ... off-topic but is all to do with security and "extraction". ... > sufficient permission to open the database, ... then they don't even need to decrypt it! ...
    (microsoft.public.access.security)
  • Re: Which is more secure RC2 or RC4 ?
    ... form to place the order with their credit card. ... same database temporarily, until the order is approved manually and the ... If by MSSQL you mean SQLServer by microsoft, they got a security concept ... bothering about encryption, use microsoft's stuff for that and spend ...
    (sci.crypt)
  • Re: setting a password on a button on the switchboard
    ... Could you send me the sample database for the fourth option (4. ... > Security in an Access database can probably be broken down into two big ... > points about being easier than User Level Security, ... > What type of data are you trying to protect? ...
    (microsoft.public.access.forms)