I need to set up a report dashboard based on data, with filters, in a big object

I'm new to salesforce, but I do have a techincal background as a DBA.

I have one big object that will contain about 100,000 rows at launch, and has the ability to filter out the rows a spceific end use needs to access. I have the SOQL listed below and have bolded the filtered ID:

select community_id__c, community_name__c, lead_id__c, first_name__c, last_name__c, spouse_first_name__c, spouse_last_name__c, lead_address__c, lead_city__c, lead_state__c, lead_zip_code__c, lead_email__c, lead_phone__c, request_create_date__c, showid__c, subscribe_id__c, subscribe_type__c from master_lead_requests__b where community_id__c = '20061105142518'

I have test data sucessfully loaded and can veiw the data in the developer console and that is as far as I have been able to get and I am not sure the best way to proceed.

1) Is there a way to associate that ID with a specfic user so when they access a report, they only have the data related to that key?
2) Do I need specific custom objects to do this, or is there a way to create a dynamic custom object that triggers based on the login user credentials?

I could be potentially adding and removing users access, and I would like to keep the maintenance aspect as simple as possible.