BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-27-2008, 09:13 AM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2007
Location: London
Model: 8310
Carrier: O2 UK
Posts: 75
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Utterly confused with SQL permissions

Please Login to Remove!

All,

I'm managing to confuse the hell out of myself with SQL permissions and role-based administration. Can anyone give me a quick summary of the permissions needed, on SQL, for the following types of users? ::

1) The main BES admin login;
2) Members of a DL which will be given the "rim_db_admin_security" role;
3) Members of a DL which wil be given the "rim_db_admin_sr_helpdesk" role;

Our DBA is very keen to minimise the number of people with sa permissions, but I have no idea which people /need/ sa in the first place!

It's a minefield out there..

Cheers

Richard
Offline  
Old 06-27-2008, 09:54 AM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
1) The main BES admin login;
sysadmin role

Quote:
2) Members of a DL which will be given the "rim_db_admin_security" role;
rim_db_admin_security role

Quote:
3) Members of a DL which wil be given the "rim_db_admin_sr_helpdesk" role;
rim_db_admin_sr_helpdesk role
Offline  
Old 06-29-2008, 01:01 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2007
Location: London
Model: 8310
Carrier: O2 UK
Posts: 75
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Hdawg.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.