Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Ainslie  
#1 Posted : Thursday, June 11, 2009 10:02:26 PM(UTC)
Ainslie
Rank: Member

Reputation:

Groups: Registered
Posts: 14

I am looking into the permissions for the SQL version and it looks like our users group has the same permissions as the super users group. I would like to create a basic users group that allows people to access the database to query data but does not allow them to edit the data tables. Is this possible?
Warwick Wood  
#2 Posted : Thursday, June 11, 2009 10:17:12 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Your database administrator should have a document titled

1. ESdat SQL Server Setup Instructions.pdf

which describes to login types.  Three levels of security are provided by default: Power User (admin); Read/Write; Read Only.  The levels are assigned by allocating the appropiate roles to the user group or individual user in SQL Server Management Studio.

If your administrator doesn't have the document we can provide it offline.

Edited by moderator Thursday, June 11, 2009 10:21:00 PM(UTC)  | Reason: Not specified

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.